Prev: What caused my paste function not to work?
Next: IF statement based on True/False that activates a certain list box
From: Scoober on 18 Mar 2010 23:25
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
From: Zoltan on 19 Mar 2010 05:53
I think this should work:

=IF(AND(S140=S141,S140="no"),"",IF(AND(S140=S141,S140="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
 | 
Pages: 1
Prev: What caused my paste function not to work?
Next: IF statement based on True/False that activates a certain list box