Adding Minimums to Formula

[Utradeshow]

Hi All,

I have this formula that I need to add minimums to.

If B36 or C36 is over 48, Minimum 25,
If B36 or C36 is over 96, Minimum 50,
If B36 or C36 is over 144, Minimum 75,

=ROUND(B36*C36/76.5,0)

 

[Joe4]

Try this:

=MAX(ROUND(B36*C36/76.5,0),LOOKUP(MAX(B36:C36),{-99999,48,96,144},{0,25,50,75}))

 

[Scott Huish]

Perhaps:
=MAX(ROUND(B36*C36/76.5,0),MIN(INT(MAX(B36:C36)/48),3)*25)

 

[Utradeshow]

Try this:

=MAX(ROUND(B36*C36/76.5,0),LOOKUP(MAX(B36:C36),{-99999,48,96,144},{0,25,50,75}))

Joe, That one seems to do the trick, Thank you.

Scott, The formula seems correct, It does give an error saying formula omits adjacent cell? Whatever that means

Thank you Guys for all your help

 

[Joe4]

You are welcome.
Glad we were able to help!