IF Formulas
 

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

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

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