#1
|
|||
|
|||
if (neg) show 0
how do I get these formulas to show "0" if they produce a neg result?
=SUM(A18-A17)*(100) =SUM(12-D10) Thank you |
#2
|
|||
|
|||
For the first one try
=IF(SUM(A18-A17)*(100)<0,0,SUM(A18-A17)*(100)) If that works apply the same logic to the second. If you need further help just ask. |
#3
|
|||
|
|||
Thanks,
That does the trick |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Page does not show header & footer | Ron O'Brien | Word | 5 | 01-04-2012 07:34 AM |
Recurring Outlook 2003 meetings do not show up. | enviroko | Outlook | 0 | 07-10-2008 06:08 AM |
Show As | Tos | Outlook | 0 | 07-08-2008 10:56 AM |
How to show help for addin functions? | Movses Asatryan | Excel | 0 | 03-02-2006 05:29 AM |
Outlook problem - Open Other User’s Folder doesn’t show Sent | imported_bankboysb | Outlook | 0 | 12-12-2005 11:41 AM |