if (neg) show 0

ram1000 · #1 09-11-2008, 10:16 AM

how do I get these formulas to show "0" if they produce a neg result?

=SUM(A18-A17)*(100)

=SUM(12-D10)

Thank you

rtankersley · #2 09-16-2008, 01:47 PM

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.

ram1000 · #3 09-16-2008, 02:30 PM

Thanks,
That does the trick

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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