Set minimum values for equation results

  • Thread starter Thread starter Jim Sykes
  • Start date Start date
J

Jim Sykes

Hi all,

I've been searching the queries here and can't find an
answer to what I'm hoping is a simple query . . . I want
my equation to ensure that any minus values are returned
as 0 but positive values should remain true. THis needs
to be within the original equation as opposed to a
separate equation doing a find and replace. Appreciate
any answers (preferably by e-mail!).

Jim.
 
Try using IF(), for example:

Put in C1: =IF((A1-B1)<0,0,A1-B1)

which will return 0 if (A1-B1) results in a minus value
with zero & positive values remaining true

Hope the above helps.

Max
 
Really, Max, I'm surprised at you.
You should have used the function that is named after you, like this:
=MAX(0,equation)
 
LOL. yes, you're right.

guess i'm always thinking of others, eh? <g>

its much neater. cheers.
 
Back
Top