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