Query on IF Function and Date Field

[Thankyou!]

Apologies if this has been covered before, but I have done a search on various keywords but can't seem to find the answer ! anyway enough babbling here is my query !

I want to use the IF function for a date field

e.g (in plain language) IF C6 > 01SEP02 Then Multiply E6 by 50 otherwise by 30

I just cant seem to get it to recognise the date.

many tks

rgds

E

 

[PhilipLawrence99]

Hi there, looking at this all you need to do is the following:

=IF(C5>DATEVALUE("01/09/02"),(F1*50),(F1*30))

where C5 equals the date and F1 equals the amount you want to multiply by.

Hope this helps.

Cheers,

 

[Thankyou!]

Obvious when you know how !!

Many thanks for your quick reply works perfectly

 

[PhilipLawrence99]

No worries. Just glad I could help.

Cheers,