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(F11N11,F11,N11), but the better
bet would be the MAX function.
=MAX(F11,N11)
--
David Biddulph

"Hammer" wrote in message
...
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)

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


"Hammer" wrote:

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)