Forum Discussion
Solved
Excel formula help
Hi everybody! Although i have been using Excel every day, the time has come today to realise i know nothing about formulas :) I'm struggling to make the attached calculator works as follows: - ...
_Milena_ , perhaps
=MAX(10,MAX(B19,B20*1000)*0.01)
Your desired result seems to be the MAXimum of the 3 values representing each argument of this formula:
=MAX(10,B19*.01,B20*10)
=MAX(10,B19*.01,B20*10)