if question

[Peter1973]

Im trying to get a simple if formula to work but it keep retuning false what have I done wrong ?

=IF(C6="12:30",20,IF(C6="11:00",25))

I need it to look in c6 if it is 12:30 return the value 20 if it is 11:00 return 25.

Any help appreciated

 

[Domski]

Try: =IF(C6="12:30"*1,20,IF(C6="11:00"*1,25))

You need to coerce the time strings into values.

Dom

 

[Weaver]

Does C6 contain formatted time values?

If so, this may be your problem

TRY

=IF(TEXT(C6,"HH:MM")="12:30",20,IF(TEXT(C6,"HH:MM")="11:00",25))

 

[Peter1973]

Thanks just when I think im getting better it goes wrong.