Trying to do an IF in cell F8:
if( M8>"","SENT",F8 )

The idea is that if M8 (a date value) is greater than nothing then F8="SENT" otherwise F8 is unchanged.

Not having much luck with it.

Did you mean to say F8 twice ?

That is a circular reference, how can F8 be "unchanged", where is the unchanged value going to come from ?

Yes I did. What I'm after (if possible) is something that changes the value of F8 ONLY IF M8 has a value.

That is easy, just take the formula that is currently in F8 and put that into your IF statement where is says F8.

There isn't currently a formula in F8, just a value...

A cell can only contain a value or a formula, not both. So it can't work the way you are trying to do it.

Hmm. Thanks Andy

You have three options:

- make the "SENT" message appear in the next door cell
- use conditional formatting to indicate it is sent
- write a macro that runs down the column replacing the value in the cells with "SENT"

Looks like at least part of my problem is the date value, just did this:

=SUM(IF(M8>"",1,0))

If M8 is a date or number the result is "0", if M8 is text the result is "1".

(My Excel skills are good, not)

When A1 is a date this formula returns "SENT" otherwise nothing.

=IF(AND(ISNUMBER(A1),LEFT(CELL("format",A1),1)="D"),"SENT", "")


My Google Foo is good.

Wish I had some Google Foo today

I've found a much simpler/cruder way to achieve what I wanted but thanks guys.