IF Formulas

[DBYRON]

If any one can help with this query would be much apprieciated i'm very in
need of it thanks;

Simple example of what i need; on my work sheet i have a row with monthly
interest rates in as column headers i.e 0.3 0.5 0.7 0.8 as under each header
is a figure i.e under 0.3 is 5 under 0.5 is 10 ect.

I have a formula which gives me a figure under the colounm header so say my
formula through out 5 i need to display in a cell the column header so 0.3.
So i need something that says IF cell=5 display 0.3 OR IF cell=10 display 0.5
OR IF cell=x display y.

Your help really appriecited thank you.

Dave

[Aladin Akyurek]

Maybe...

=LOOKUP(5,NumberRange,HeaderRange)

DBYRON wrote:
> If any one can help with this query would be much apprieciated i'm very in
> need of it thanks;
>
> Simple example of what i need; on my work sheet i have a row with monthly
> interest rates in as column headers i.e 0.3 0.5 0.7 0.8 as under each header
> is a figure i.e under 0.3 is 5 under 0.5 is 10 ect.
>
> I have a formula which gives me a figure under the colounm header so say my
> formula through out 5 i need to display in a cell the column header so 0.3.
> So i need something that says IF cell=5 display 0.3 OR IF cell=10 display 0.5
> OR IF cell=x display y.
>
> Your help really appriecited thank you.
>
> Dave
>

[Zack Barresse]

Also posted in the public.excel.newusers section, with answers; as well as
public.excel.programming.

You should really try and limit yourself to the correct newsgroup..


--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"DBYRON" <DBYRON@discussions.microsoft.com> wrote in message
news:A37EA15E-9DF8-4D43-A8EE-F55A1ED511BF@microsoft.com...
> If any one can help with this query would be much apprieciated i'm very in
> need of it thanks;
>
> Simple example of what i need; on my work sheet i have a row with monthly
> interest rates in as column headers i.e 0.3 0.5 0.7 0.8 as under each
> header
> is a figure i.e under 0.3 is 5 under 0.5 is 10 ect.
>
> I have a formula which gives me a figure under the colounm header so say
> my
> formula through out 5 i need to display in a cell the column header so
> 0.3.
> So i need something that says IF cell=5 display 0.3 OR IF cell=10 display
> 0.5
> OR IF cell=x display y.
>
> Your help really appriecited thank you.
>
> Dave
>