IF function
 

Hi I am trying to put a formula together it's quite easy but I can't figure
it out. What I want to do is subtract cell C3 from C2 and place the results
in C4 but only if there is more than 0 in C3, if there is zero in C3 I just
want a zero in C4 and not what is in C2. I have tried "if" and "sumif"
functions.

IF function
 

Try this in C4:

=IF(C3=0,0,C2-C3)

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Davidinsf" wrote:

Hi I am trying to put a formula together it's quite easy but I can't figure
it out. What I want to do is subtract cell C3 from C2 and place the results
in C4 but only if there is more than 0 in C3, if there is zero in C3 I just
want a zero in C4 and not what is in C2. I have tried "if" and "sumif"
functions.