View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default If formula problems

Another way:

=D20-ABS(D19)
--

HTH,

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


"Canon" wrote in message
...
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.