Excel gurus... need your help.

MrsHughesNC · September 2010

I am trying to find the right formula/IF statement to determine this:

if D1 is greater than D2, then D3 = the difference between the two, and if D2 is greater than D1, then D3 = 0.

Can anyone help? I use excel every day for basic stuff, but have never had to do an If statement, somehow.

TIA!

becki777 · September 2010

Try this - I think it works!
=IF(D1<D2,D1+D2,0)

elissaann26 · September 2010

=IF(D1>D2, D1-D2, 0)

The format for if statements is = IF( statement you are testing , what happens if it is true , what happens if it isn't true )

MrsHughesNC · September 2010

Thanks y'all--perfect!

raceyrae · September 2010

elissaann26:

=IF(D1>D2, D1-D2, 0)

The format for if statements is = IF( statement you are testing , what happens if it is true , what happens if it isn't true )

This is the correct one.

Want a personalized experience?

Excel gurus... need your help.

Re: Excel gurus... need your help.

Choose Another Board

Search Boards