If, then, else

[Airskip2012]

Hello.

I have been pulling my hair out on this one. I know this is easy, but it seems the help areas are just not geared for exactly what I need.

I am tracking some purchases against estimated quantities. Basically I want to subtract the sum of the estimated quantities from the sum of the received quantities and yield the (>0) difference, otherwise yield a "0".

Here is my logic:

If the sum of cells (row) minus the sum of cells is greater than 0, I want that value, otherwise I want a 0. Sounds simple, but I can't get it to work.

Here is my most recent effort (and I still get a #VALUE! answer):

=IF(SUM(P4:S4)-SUM(F4:O4)>0),SUM(P4:S4-F4:O4),0

Thanks in advance for your help!

[bebo021999]

Try this:
=MAX(SUM(P4:S4)-SUM(F4:O4),0)

[mahju]

Hi

Try this amendment

Please Login or Register  to view this content.

[Airskip2012]

Thanks Fellas,

Both options worked great! Joining this forum is the best business decision I've made, today. I'm sure I'll need you again.

[mahju]

Hi
You are welcome.

Make sure you have made the thread as solved.

See my signature for help

Regards