Adding a max and min to an IF formula in Excel 2010

[yamaha333]

Hi,
Hoping someone might be able to help. I have, eventually, completed my IF formula, but want to add a limit to the number it returns. I do not want any negative numbers (these should be displayed as '0') and I want to limit the maximum number to that of a specific cell, O12.

The formula is as follows-

=IF((K18/K12*O12)<(O12-((M12-M18)*G12)),(K18/K12*O12),(O12-((M12-M18)*G12)))

Does this make sense to anyone?

Thanks in advance.

[Andrew-R]

Something like this, I think:

=MAX(0,MIN(IF((K18/K12*O12)<(O12-((M12-M18)*G12)),(K18/K12*O12),(O12-((M12-M18)*G12))),O12))

[yamaha333]

Wow, thanks ! Worked perfectly.
Please can you do the same to this, more simple, formula?

=O12-((M12-M14)*G12)

No negatives and not higher than cell O12, please.

Thanks again..

[Andrew-R]

Sure, it's easy enough to do:

=MAX(0,MIN(O12-((M12-M14)*G12),O12))

[yamaha333]

Thank you, Andrew. A big help !!