LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Problems SaraHall :) Excel Discussion (Misc queries) 5 September 3rd 08 11:59 PM
formula problems Cyndi Excel Discussion (Misc queries) 1 November 9th 07 12:39 AM
Formula problems dew244 Excel Discussion (Misc queries) 2 April 6th 07 12:14 PM
Formula problems Sharon A Excel Discussion (Misc queries) 2 March 3rd 06 12:06 PM
formula problems Ted Excel Worksheet Functions 0 November 26th 05 04:38 PM


All times are GMT +1. The time now is 04:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"