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

Thread: If formula