IF Statement help please?

[apearson]

Hi All veiwing members,

Can someone help with my IF statement as shown below please:-

=IF(A10<>"",IF(G3="",NOW(),G3),"")

When data is entered into 'A10' then 'G3' records the date/time.

My problem is, I want 'G3' to record the date/time if data is entered into any cell from 'A10:A200', but just can't find anything that works?

Also does it matter if data is entered into more than one cell in Col A?

Using Excel 2003

Thank you

Alley

 

[apearson]

VoG,

Not sure what happened the first time, but works fine now.

Thank you so much for giving of your time.

It's my endeavour to help someone else who posts a question one day, when I'm clever enough!

Thanks again

Alley