SUM IF Question

[#1]

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

[MK_QSL]

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

[sunny_talwar]

This?

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

[Mark_Little]

Hi,

Either of the above should work,

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

Mark

[Anonymous · Accepted solution]

like this?

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

[#6]

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