5 Replies Latest reply: Nov 17, 2015 9:41 AM by Nicklas Thorén

# SUM IF Question

Hi everyone,

Trying my very best to figure this one out.

I'd like to make a conditional expression based on the followind.

SALES1=4

SALES2=4

ITEMs=3

My expression needs to pre-calculate the following condition, explained as:

If the sum of SALES1 subracted from SALES2 is larger than ZERO, then subract SALES1 from SALES2, multiply by items, divided by 0,8

Trying my best, but in need of help.

Many thanks!

Regards,

Nick

• ###### Re: SUM IF Question

=IF(SUM(SALES1) - SUM(SALES2) > 0, (SUM(SALES2) - SUM(SALES1)) * ITEMs / 0.8)

• ###### Re: SUM IF Question

This?

If(Sum(SALES2 - SALES1) > 0, ((SALES2 - SALES1) * (ITEMs/0,8)))

• ###### Re: SUM IF Question

Hi,

Either of the above should work,

Formatting wise Sunny's would be the approach I would take.

Mark

• ###### Re: SUM IF Question

like this?

=if((sum(SALES1 - SALES2))>0, ((SALES2-SALES1)*ITEM)/0.8)

• ###### Re: SUM IF Question

Thanks everyone for your input! Tried the different solutions and found Balraj's example to work best for me.