Not More Than or Maximum in a formula

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

Hopefully fourth time's the charm on trying to post this question:

Is there a way to have excel limit a sum to not more than ____? The
formula as it stands is =IF(AND(C16="Pharmacy",ISNUMBER
(X16),D16>5),D16-5). To that final equation, I'd like the sum to
result in a maximum or ceiling of $30. I've tried it with MAX a few
different ways so far, (e.g., ... MAX(D16-5, 30)) but no luck.
 
Hopefully fourth time's the charm on trying to post this question:

Is there a way to have excel limit a sum to not more than ____? The
formula as it stands is =IF(AND(C16="Pharmacy",ISNUMBER
(X16),D16>5),D16-5). To that final equation, I'd like the sum to
result in a maximum or ceiling of $30. I've tried it with MAX a few
different ways so far, (e.g., ... MAX(D16-5, 30)) but no luck.
Click to expand...

Try this formula:

=MIN(D16-5,30)

Hope this helps / Lars-Åke
 
Try this formula:

=MIN(D16-5,30)

Hope this helps / Lars-Åke
Click to expand...

Perfect!

Now if someone can figure out why I wasn't allowed to post this
question directly on Microsoft Online....?
 
Back
Top