| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement not returning the value i need
please see following formula:
=IF(M81100<750,"6000100","4200710")&IF(M81=750," 1201060","4200710")&IF(I81="TONER","6001000","4200 710") I need to return numbers in a cell if the $ is less than 100, return 4200710, greater than 100 but less than 750, return 6000100, and if 750, return 1201060 and then if "I" column has the text "TONER" return 4700710. this the result of my formula, i know i am close and i just missing the "key" elements to get this to work..excel 2007 420071012010604200710 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement not returning a blank so a chart line won't gap | Charts and Charting in Excel | |||
| Logical test in IF statement returning incorrect result | Excel Worksheet Functions | |||
| Returning a string of values in an IF statement | Excel Discussion (Misc queries) | |||
| Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
| Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
Threaded Mode
