Home |
Search |
Today's Posts |
#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
|
|||
|
|||
Hello there,
I'm going to assume that you do not have this list in a tabulated table. This would of course be easiest, imho, but defenitely workable without it. Assuming you are wanting to look at cell A2, putting the formula in A3, you could use something like this ... =LOOKUP(A19,{5,10,15,20,25,30},{0.3,0.5,0.7,0.9,0. 11,0.13}) There are a couple of things to mention about this formula. There are 3 syntactical portions to it. The two I'll mention about are the second and third parts. The second part is the lookup table (aka lookup_vector), the third one is the return table (aka result_vector). The lookup table MUST be in ascending order either numerically and/or alphabetically, just as the sort method would. Also, the return table must be of equal size to the lookup table. And text must be enclosed in quotations with this function, but can also be used. HTH -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |