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)