Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULAS THAT CAN HAVE DIFFERENT ANSWERS DEPENDING ON DATA INPUT
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
How to Prevent Duplicate Data from inputing using input application? | Excel Worksheet Functions | |||
How to Prevent Duplicate Data from inputing using input application? | Excel Discussion (Misc queries) | |||
How to Prevent Duplicate Data from inputing using input application? | New Users to Excel | |||
Excel 2002; copy formulas to one workbook to another diff data | Excel Worksheet Functions |