Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF FUNCTION, ADD MULTIPLE NUMBERS
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?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF FUNCTION, ADD MULTIPLE NUMBERS
Let's look at a simpler problem to start with
=OR(G8=32,H8=32,I8=32)*(C8-26)+OR(G8=40,H8=40,I8=40)*(C8-2) If any of G8,H8 or I8 has value 32, we add C8-26 to our sum If any of G8,H8 or I8 has value 40, we add C8-2 to our sum So if C8 has value 60, and G8 is 32 while H8 is 40, our sum is 92 If this is correct fro you then just extend the formula being careful with parentheses -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... 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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup when there is multiple same numbers | Excel Worksheet Functions | |||
Multiple results from multiple criteria using IF function | Excel Discussion (Misc queries) | |||
Multiple Sheet, Multiple Criteria Look-Up Function Help | Excel Worksheet Functions | |||
Can you add multiple numbers in the same cell%3f | Excel Worksheet Functions | |||
Words > Numbers (i.e. Vanity Phone Numbers) function | Excel Worksheet Functions |