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

"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

using a "nested if, then else" statement write formula as follows: (note
only 7 nested values allowed, hence if you have more than 7 columns you'll
need a more sophisticated macro). Below is example with columns of
..3,.5,.7,.8.

if(a1=.3,"5",if(a1=.5,"10",if(a1=.7,"15",if (a1=.8,"20",0))))

Try confining yourself to the correct group for posting. Making duplicate
posts everywhere can be frustrating for those who are helping. This should
only be in the worksheetfunctions group.

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