If formula problems

  • Thread starter Thread starter Canon
  • Start date Start date
C

Canon

Excel 2007
Please help with a formula to do the following;
if D19 is less then or equal to 0.00 then D20+D19, if D19 is greater then
0.00 then D20-D19
I hope this did not post twice.
 
Another way:

=D20-ABS(D19)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Excel 2007
Please help with a formula to do the following;
if D19 is less then or equal to 0.00 then D20+D19, if D19 is greater then
0.00 then D20-D19
I hope this did not post twice.
 
Back
Top