Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What function do I use to return a certain value for specific text
e.g. if 5-2100 is entered into A1 then A2 should automatically = $31.00, if
5-6100 is entered into A1 then A2 should automatically = $36.00. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need subtotal function to return text as result | Excel Discussion (Misc queries) | |||
If function with text | Excel Worksheet Functions | |||
UPPER text function | Excel Discussion (Misc queries) | |||
Return value with using Excel function | New Users to Excel | |||
Convert Numeric into Text | Excel Worksheet Functions |