Date in if statment

[kings21]

How do I enter a date in an if statement? I need to calculate cost directly associated with a workers wage. They got a raise on a certain date so if it's before that date i need to multiply by 23 and after by 24. I tried this but it doesn’t seem to be working.

=IF(C40>4/30/2008,IF(D39=""," -",IF(D39="J",F39*24.5,IF(D39="D",F39*27.5,IF(D39="F",F39*23,IF(D39="An",F39*27,IF(D39="Al",F39*14)))))),IF(D35=""," -",IF(D35="J",F35*24.5,IF(D35="D",F35*27.5,IF(D35="F",F35*22,IF(D35="An",F35*27,IF(D35="Al",F35*14)))))))

 

[Jonmo1]

Written like that, excel reads it like

iF C40 > (4 Devided by 30 devided by 2008)

Couple ways to do it..
If(C40>"4/30/2008"*1
or
If(C40>DATE(2008,4,30)
or
IF(C40>A1 'Where A1 = 4/30/2008

Hope this helps...

 

[Kelbo]

Hi kings21,

One problem is that nested 'if' statements are limited to 7 'ifs'.

You will have to rethink your task!

Kelbo

 

[kings21]

Awesome!! Used the second one and it worked perfectly!! Thank you so much.