Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Negative Numbers

0 views
Skip to first unread message

sharp

unread,
Jul 17, 2003, 1:37:57 PM7/17/03
to
I'm trying to replace any negative numbers with a zero
that appears in one particular row. This row is already
calculating two other rows. Any suggestions on creating a
nested if statement or any other possibilities?

Paul Corrado

unread,
Jul 17, 2003, 1:46:02 PM7/17/03
to
You can use SUMPRODUCT or an Array Formula to ignore the negative numbers,
thus eliminating the problem. Without knowing the specifics of the
calculations involved it is difficult to provide an exact solution.

PC

"sharp" <lsh...@shelbygroup.com> wrote in message
news:013001c34c8a$28ff3e80$a401...@phx.gbl...

Ken Wright

unread,
Jul 17, 2003, 6:02:46 PM7/17/03
to
Assuming your formula was =A1-A2, then the following will bottom it out at 0:-

=MAX(A1-A2,0)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

"sharp" <lsh...@shelbygroup.com> wrote in message news:013001c34c8a$28ff3e80$a401...@phx.gbl...

0 new messages