We have two pricing models for an item.
Price 1
= Cell 1Price 2
= Cell 2
Is there a formula that I can use where the price for the customer would be the whichever is higher among Price 1
and Price 2
?
We have two pricing models for an item.
Is there a formula that I can use where the price for the customer would be the whichever is higher among 


Please try the following:
When done, B4 better be 35 It also works on rectangular ranges
When done, B4 better be 37 To be honest, both question and answer are trivial. Using the B4 Cell, when you type =MAX, a little help screen pops up to give you the option to add cells/values. I am using Excel 2010, BTW Click on the Click on the Sigma's DropDown Arrow and Choose More Functions. You will get a list of Functions available in Excel to Insert into the Cell. 

