PDA

View Full Version : [SOLVED:] If formula


gibbo1715
08-19-2005, 04:05 AM
Can anyone help with the formula below that doesnt work, i need to check two values in my if statement


=IF(AND(L4 = "47/3",C4 <today),1,0)

Cheers

Gibbo
Sir Babydum GBE
08-19-2005, 04:23 AM
Is this what you need?


=IF(AND(L4 = "47/3",C4<TODAY()),1,0)
gibbo1715
08-19-2005, 04:24 AM
That is exactly it, and works great thanks

Gibbo
TonyJollans
08-19-2005, 04:42 AM
Nothing syntactically wrong with the formula (bar the missing parentheses in TODAY()).

Do you really expect a text value of "47/3" in cell L4?
TonyJollans
08-19-2005, 04:44 AM
Should have refreshed before posting! Glad you're sorted!
gibbo1715
08-19-2005, 05:12 AM
thanks for your help anyway tony, it is appreciated
gibbo1715
08-22-2005, 10:48 AM
does the job, thanks again

Gibbo