| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Omitting Negative Numbers
Hi there,
I'm wondering if there is a formula that will omit a number from a table when it is negative. If so, please inform me how to add it to a formula that looks like this: =SUM(B90,B109,B149,B168)-B128-B187 Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Omitting Negative Numbers
=MAX(B90,0)+MAX(B109,0)+MAX(B149,0)+MAX(B168,0)-MAX(B128,0)-MAX(B187,0)
-- Gary''s Student - gsnu200846 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| deleting or omitting "-"'s in a group of numbers w/ a formula | Excel Discussion (Misc queries) | |||
| omitting/deleting "-"'s from numbers w/ formula | Excel Discussion (Misc queries) | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
| omitting column letters and numbers of rows | Excel Discussion (Misc queries) | |||
Linear Mode
