yes or no by a condition formula

[John Caines]

Hello All.
I have a range:
W24:W274.
after each day a £ amount is entered, so at present (After 3 weeks) it has 15 entries in (5 per week-Mon -Fri).
In the column next to it, Actually it's Column U merged across with Column V, there are some other £ amounts.

What I'm wanting to do is this;
If the LAST entered Cell in Column W is greater than the amount in the column to its left (Column U merged with V), I want to display the word YES In cell Q9.
If The Last Entered Cell In Column W is LESS than the amount in column to the left of it ,, cell Q9 will display the word "NO"....

Simple?
Can I do it, no,,,
Trying to find it on forum,, I'm sure its a common 1.
If someone can point me in the right direction please.

Many Thanks
john Caines

 

[Aladin Akyurek]

Great stuff Dryver14,,, !! Working.

It's 4.30am here,, just had to look before I go to work (God how I hate early morning Saturday 12 hr shifts ,,,)

Excellent.
Many thanks for this,, not many cells to go now,,
I think I can fill the others in, I'll try when I'm back from work.

As to your formula Aladin Akyurek,
It returned a No or a Yes,, but for the Q9 cell it needed to return the actual amount opposite the cell in column W (So if the last filled cell in w was W35, I needed to show the £ amount in Q9 from cell U35).

Many thanks for your input also, all greatly appreciated.

All the best
A very grateful
John Caines

Doesn't your initial post mention the YES/NO thing...

Try to experiment with waht you get. The formula I posted is easly converted into one that reurns what you need:

=LOOKUP(9.99999999999999E+307,W24:W274,U24:U274)

Again, no OFFSET is needed.