If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Extend data range format and formulas | denise | Worksheet Functions | 1 | February 2nd, 2005 06:46 AM |
Problem with named formula's | nathan | Worksheet Functions | 0 | January 21st, 2005 04:07 PM |
importing data and formulas into Excel | Eric | General Discussion | 2 | August 25th, 2004 12:12 AM |
Trouble with protected sheets & formulas | Peter Bernadyne | General Discussion | 6 | August 11th, 2004 02:54 PM |
Copying formulas with ranges | Carla S | Worksheet Functions | 2 | December 18th, 2003 07:06 PM |