formula requirement
worked great thanks
"Ron Coderre" wrote:
Try this:
=CHOOSE(TRUNC((G10-1)/5)+1,"a","b","c","d")
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"pcor" wrote:
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
|