View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bell Bell is offline
external usenet poster
 
Posts: 5
Default IF FUNCTION, ADD MULTIPLE NUMBERS

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??