formula requirement
 

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

formula requirement
 

Hi

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

--
Regards

Roger Govier


"pcor" wrote in message
...
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

formula requirement
 

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

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

formula requirement
 

Also worked great...Thanks

"Roger Govier" wrote:

Hi

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

--
Regards

Roger Govier


"pcor" wrote in message
...
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

formula requirement
 

Very neat, Ron

--
Regards

Roger Govier


"Ron Coderre" wrote in message
...
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

formula requirement
 

Thanks, Roger

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

XL2002, WinXP-Pro


"Roger Govier" wrote:

Very neat, Ron

--
Regards

Roger Govier


"Ron Coderre" wrote in message
...
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