If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Addition to a working formula
I have this formula and it works fine.
=IF(OR(S140="No",S140="0"),"",G140*X140) This is placed in cell p159 I now need to add the exact same information as above to the cells immediately below the cell listed above. so Orinal cells involved G140 = data s140 = yes/no x140= % I now need the answer of g141 s141 and x141 to be added to the reult of g140 s140 x141 in p159 if 'yes' is placed in s141, but not added if 'no' is entered into s141 To summarise - i need the answers of the 140 and 141 lines to be placed into p159 independantly of each other. so if 'no' is placed in either line then the other formula will still add whats required if yes is elected in the other line. At the same time if 'yes' is selected in both lines then the sum of both lines need to be calculated and printed in p159. I hope this makes sense? Thanks in advance. Scoober |
#2
|
|||
|
|||
Addition to a working formula
I think this should work:
=IF(AND(S140=S141,S140="no"),"",IF(AND(S140=S141,S 140="yes"),G140*X140+G141*X141,IF(S140="yes",G140* X140,G141*X141))) Please click yes if helpful "Scoober" wrote: I have this formula and it works fine. =IF(OR(S140="No",S140="0"),"",G140*X140) This is placed in cell p159 I now need to add the exact same information as above to the cells immediately below the cell listed above. so Orinal cells involved G140 = data s140 = yes/no x140= % I now need the answer of g141 s141 and x141 to be added to the reult of g140 s140 x141 in p159 if 'yes' is placed in s141, but not added if 'no' is entered into s141 To summarise - i need the answers of the 140 and 141 lines to be placed into p159 independantly of each other. so if 'no' is placed in either line then the other formula will still add whats required if yes is elected in the other line. At the same time if 'yes' is selected in both lines then the sum of both lines need to be calculated and printed in p159. I hope this makes sense? Thanks in advance. Scoober |
Thread Tools | |
Display Modes | |
|
|