ExcelBanter - Omitting Negative Numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Omitting Negative Numbers (https://www.excelbanter.com/excel-discussion-misc-queries/227987-omitting-negative-numbers.html)

Caplin Girl

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.

Gary''s Student

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

All times are GMT +1. The time now is 02:22 AM.