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
|
|||
|
|||
FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT
I am hoping that someone can help me out. I want to create a formula or
function that will do basically this If I put a certain number into a cell (e6), then depending on what number I put in that cell the corresponding number will appear into another cell (f6). Basically ............. if I say 322 in e6, then 149 will appear in f6 or if I put 311 in e6, then 99 will appear in f6 and so on. Can someone please help me out?? |
#2
|
|||
|
|||
FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT
|
#3
|
|||
|
|||
FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT
Use the VLOOKUP function.
A tutorial can be found he http://www.contextures.com/xlFunctions02.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Dawn" wrote in message ... |I am hoping that someone can help me out. I want to create a formula or | function that will do basically this | | If I put a certain number into a cell (e6), then depending on what number I | put in that cell the corresponding number will appear into another cell (f6). | | Basically ............. if I say 322 in e6, then 149 will appear in f6 or if | I put 311 in e6, then 99 will appear in f6 and so on. | | Can someone please help me out?? |
#5
|
|||
|
|||
FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT
Dawn
You can put into cell f6 either of the following formulas and it will do basiclly what you asked: =50/11*e6-1314.636363 or =IF(e6=322,149,IF(e6=311,99,"who knows?")) Of course their are lots of other formulas that will work as well. I think if you explain a little more about the relationship between e6 and f6 someone in this group will give you an answer that will work for you. Good luck. Ken Norfolk, Va Niek Otten wrote: Use the VLOOKUP function. A tutorial can be found he http://www.contextures.com/xlFunctions02.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Dawn" wrote in message ... |I am hoping that someone can help me out. I want to create a formula or | function that will do basically this | | If I put a certain number into a cell (e6), then depending on what number I | put in that cell the corresponding number will appear into another cell (f6). | | Basically ............. if I say 322 in e6, then 149 will appear in f6 or if | I put 311 in e6, then 99 will appear in f6 and so on. | | Can someone please help me out?? |
Thread Tools | |
Display Modes | |
|
|