formula requirement

[pcor]

In g10 I will have one of four answers:
it could be 1 to 5
6 to 10
11 to 15
16 to 20
If the answer sd 1 to 5 I want the response to be "a"
should the answer in G10 between 11 and 15 I want to return "c"
Will someone please help with the foluma.
Thanks

 

[Roger Govier]

Hi

Try
=IF(G10<6,"a",IF(G10<11,"b",IF(G10<16,"c","d")))

 

[Ron Coderre]

Try this:
=CHOOSE(TRUNC((G10-1)/5)+1,"a","b","c","d")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[pcor]

worked great thanks

Try this:
=CHOOSE(TRUNC((G10-1)/5)+1,"a","b","c","d")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[pcor]

Also worked great...Thanks

Hi

Try
=IF(G10<6,"a",IF(G10<11,"b",IF(G10<16,"c","d")))

 

[Roger Govier]

Very neat, Ron

--
Regards

Roger Govier

Try this:
=CHOOSE(TRUNC((G10-1)/5)+1,"a","b","c","d")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Ron Coderre]

Thanks, Roger

***********
Regards,
Ron

XL2002, WinXP-Pro