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
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?
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
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.
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
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