Firstly, please get your caps lock key repaired so that you can stop
SHOUTING.
Secondly, your formula looks particularly confusing because you have many
unnecessary sets of parentheses.
=IF(OR(G8=32,H8=32,I8=32),C8-26,IF(OR(G8=40,H8=40,I8=40),C8-2,IF(OR(G8=50,H8=50,I8=50),C8-50,IF(OR(G8=65,H8=65,I8=65),C8-60,IF(OR(G8=100,H8=100,I8=100),C8-70,IF(G8=100,C8-80,0))))))
would do.
Thirdly, you refer to wanting "ALL THE OUTCOMES TO BE ADDED TOGETHER AS ONE
NUMBER", but I don't know what you mean by "all the outcomes". You have a
nested IF statement which returns one outcome. The other point is that with
the way you've got the nesting, your final IF function is unnecessary;
G8=100 is one of the conditions for the OR in the previous IF condition, so
if G8=100 you satisfy the conditions for that previous IF statement and thus
don't proceed to the alternative outcome, which is the final IF.

You may want to reformulate your statement and explain what it is that you
are trying to achieve.
--
David Biddulph


"BELL" wrote in message
...
HI,

WHAT CAN I DO? THIS IS MY FORMULA

=(IF((OR(G8=32,H8=32,I8=32)),C8-26,(IF((OR(G8=40,H8=40,I8=40)),C8-2,(IF((OR(G8=50,H8=50,I8=50)),C8-50,(IF((OR(G8=65,H8=65,I8=65)),C8-60,(IF((OR(G8=100,H8=100,I8=100)),C8-70,IF(G8=100,C8-80,0)))))))))))

I NEED FOR ALL THE OUTCOMES TO BE ADDED TOGETHER AS ONE NUMBER AND TAKEN
AWAY FROM C8.

ANY IDEAS??