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