| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula string
I'm having trouble creating a formula that performs the following function.
I want there to be a certain text output dependent upon which range bucket the value in cell T87 falls into. Each bucket clause works when entered individually, but when put together separated by commas, the output is #VALUE. Is there a way to set up the formula so that only the TRUE response is given and the FALSE responses are ignored? I've included the formula for reference. Thanks for any help! =IF(T87=10000,"6% Net 90"),IF(AND(T87=8000,T87<10000),"5% Net 90"), IF(AND(T87=5000,T87<8000),"4% Net 75"),IF(AND(T87=3000,T87<5000),"3% Net 75"), IF(AND(T87=2000,T87<3000),"2% Net 60"), IF(AND(T87=1000,T87<2000),"1% Net 60"),IF(T87<1000, "0% Net 30") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a Formula stored as String to real Formula | Excel Worksheet Functions | |||
| formula for text string | Excel Worksheet Functions | |||
| Formula to Replace or eliminate any sheetname(s) in formula string | Excel Discussion (Misc queries) | |||
| formula with text string | Excel Discussion (Misc queries) | |||
| Evaluate string as a formula | Excel Worksheet Functions | |||
Threaded Mode
