If Function

[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)

 

[David Biddulph]

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)

 

[JLatham]

Use the MAX() function, as:
=MAX(F11,N11)