Excel 2003 Problem

  Zeltine 19:01 01 Mar 2005
Locked

Ok here is the problem: I am uding this basic IF statement: =IF(I9 =10, "Order","Ok"),where I9 is a total. What function would I use to get the spreadsheet to automatically insert the current date when the above formula changes from Ok to Order, or when it changes from Order to Ok to display nothing. Am I asking the impossible here?

Thanks in advance...

  VoG II 19:04 01 Mar 2005

=IF(I9=10,TODAY(),"")

and format the cell with that formula as Date.

  Zeltine 19:10 01 Mar 2005

I have seen you work your magic in here before VOG, and I am ultimately greatful, no long night here at work, wahey. Do you have any good excel reference sites? I need to refresh from my uni days?

Thankyou for you quick response.

Peace, Love and Light

  VoG II 19:18 01 Mar 2005

click here click here click here click here

for a few. Peter Noneley's Excel Function Dictionary is no longer available to download but if you would like a copy send me a message via my yellow envelope. It is a workbook with examples of most worksheet functions that you are ever likely to need.

  tasslehoff burrfoot 20:21 01 Mar 2005

May I also contact you via your yellow envelope for a copy of this?

Many thanks

Tas

  stalion 20:27 01 Mar 2005

good evening to you and I don't want a copy but more power to your elbow.
Regards

  VoG II 20:36 01 Mar 2005

Yes of course. The same applies to all forum members.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Les meilleures tablettes 2017