IF to check a calculation result

Hi all,

I'm just wondering - I have a situation where I need to run a calculation based on other cells' values, then check to see if the result of the calculation is over a certain amount and if not, display a particular value, but if it is over the threshold amount, to display the actual result of the calculation. (I'm building a calculator to give to managers in my organization to let them calculate salary ranges for positions in their departments including adjustments based on geographical region, and we have an internal minimum wage of $12/hr, so if the geo-adjusted result is under $12 it needs to be bumped up.)

Normally I do something like

Please Login or Register  to view this content.

so that the action taken if the test returns "false" is itself the formula from the test.

However, in this instance the calculation itself is a ridiculous bear involving index/match and bits and pieces from several sheets, so I'm trying to avoid having to repeat the whole thing. So if I do it my usual way, I would end up with

Please Login or Register  to view this content.

Is there a shorter way to express that? Because that piece is itself nested in another IF, because there are two possible calculations it might need to run depending on the text in a third place, so that means I'd have that long index/match calculation string repeated 4 times in one formula! And I can do that, but it looks messy and seems inefficient, and I'm wondering if there's a trick to this that I just haven't figured out yet.

Thanks!

Given the simple version
=IF(A1*B1<12,12,A1*B1)

Try
=MAX(12,A1*B1)

Perfect! Works a treat. I'd never heard of the MAX function before, thank you SO much!

You're welcome.

FYI, there is also a MIN function. And you might guess that it works exactly the opposite.

MIN(12,A1*B1)

If the A1*B1 is GREATER than 12, then it returns 12, otherwise returns the result of A1*B1