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!

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!

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!