If Function

  • Thread starter Thread starter Hammer
  • Start date Start date
H

Hammer

I want a cell to show the highest value based on the criteria below, Could
somebody provide me with a simple formula to show this, I presume I would
have to use the If Function.

For example

If cell F11 = £200 & Cell N11 = £146 I would like cell O11 to return the
highest value (£200)
 
You could use the IF function, such as =IF(F11>N11,F11,N11), but the better
bet would be the MAX function.
=MAX(F11,N11)
 
Back
Top