If function (97)

Topic

New Reply

Hello, how do I code a formula to achieve my requirments in this scenario:

I want my cell to return a value of 0 if the calulation from other cells returns a negative number else return the value of those other cells if positive? i.e. in G5 if D5 – D4 is negative return 0 else return the positive value from D5-D4?

Thanks Darren.

Reply | Quote

Replies

In your specific case, I like =MAX(0,D5-D4). If you really prefer IF, then =IF(d5-d4<0,0,d5-d4).

Reply | Quote