Forum Discussion
Formula Help IF and MAX together, I think....
Hello i am trying to create a formula that when TRUE will display whichever is greater a number in the formula or the results of a calculation of other cells. Whenever i try and use this I either get an error message or it will only display 55.
=IF(D35,MAX(55,(E22+E24)*10),"")
In general the formula is correct, but result is very depends on what is in your cells
