Need help on a formula

[wicket_wm]

I need a formula to calculate the following information please: I will have
someone enter a time (ex 6:31) in cell C3. If the time matches one of the
times in cells B17-B22 I need it to display 4.6, if it matched one of the
times in cells B23-28 I need it to display 4.7, if it matches one of the
times in cells B29-34 I need it to display 4.8 and so on. Does anyone have a
simple formula I can do for this please?

 

[Fred Smith]

=IF(COUNTIF(B17:B22,C3)>0,4.6,IF(COUNTIF(B23:B28,C3)>0,4.7,IF(COUNTIF(B29:B34,C3)>0,4.8,"no
match")))

Can't do the "and so on" part, but hopefully you get the picture.

Regards,
Fred

 

[Ms-Exl-Learner]

Try this...

=IF(COUNTIF(B17:B22,C3)>=1,4.6,IF(COUNTIF(B23:B28,C3)>=1,4.7,IF(COUNTIF(B29:B34,C3)>=1,4.8,"")))

Remember to Click Yes, if this post helps!

 

[Teethless mama]

Try this:

=ROUNDUP(MATCH(C3,B17:B100,)/60,1)+4.5

 

[Gary Keramidas]

i think you mistyped an extra comma:

ROUNDUP(MATCH(C3,B17:B100)/60,1)+4.5