| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set up 10 value formula with (+) and (-) in it
How do I set up a 10 value IF formula that contains + and - in the answer,
i.e. 4+, 5-, etc? I've tried +IF(C28200,4+,IF(C28193,4,IFC28188,4-))) and I get an error with the cursor at the first + sign. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Set up 10 value formula with (+) and (-) in it
If you just need a displayed value:
Maybe this: =IF(C28200,"4+",IF(C28193,"4",IFC28188,"4-"))) or this.... =LOOKUP(C28,{0,189,194,201},{"","4-","4","4+"}) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "jmommad" wrote: How do I set up a 10 value IF formula that contains + and - in the answer, i.e. 4+, 5-, etc? I've tried +IF(C28200,4+,IF(C28193,4,IFC28188,4-))) and I get an error with the cursor at the first + sign. Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Set up 10 value formula with (+) and (-) in it
There is a limit of 7 nested IF's to a cell, so you may want to use a VLOOKUP
table with your lookup values in column A and answers in column B Or a formula similar to this =LOOKUP(B1,{200,193,188,181,175},{"4+","4","4-","3+","3"}) Gord Dibben MS Excel MVP On Wed, 6 Dec 2006 11:53:01 -0800, jmommad wrote: How do I set up a 10 value IF formula that contains + and - in the answer, i.e. 4+, 5-, etc? I've tried +IF(C28200,4+,IF(C28193,4,IFC28188,4-))) and I get an error with the cursor at the first + sign. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
