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

Hi

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

--
Regards

Roger Govier


"pcor" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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
>

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
> >

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>
>

Very neat, Ron

--
Regards

Roger Govier


"Ron Coderre" <[email protected]> wrote in message
news:[email protected]...
> 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
>>

Thanks, Roger

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

XL2002, WinXP-Pro


"Roger Govier" wrote:

> Very neat, Ron
>
> --
> Regards
>
> Roger Govier
>
>
> "Ron Coderre" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >>
>
>
>