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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.