A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Addition to a working formula



 
 
Thread Tools Display Modes
  #1  
Old March 19th, 2010, 04:25 AM posted to microsoft.public.excel.worksheet.functions
Scoober
external usenet poster
 
Posts: 95
Default 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  
Old March 19th, 2010, 10:53 AM posted to microsoft.public.excel.worksheet.functions
Zoltan
external usenet poster
 
Posts: 16
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.