Help
 

I am a student I Niagera college and am working with excel, I have a n
ifstatmet that is giving the correct answer but its not solving the anser.

The statment : =IF(G9B3,+"sum(G9*C3)",+"sum(G9*1)")

The Answer sum(G9*C3)

The problemi is that it is the wright answer but it will not tally the sum.

Help me PLZ

How about:

=IF(G9B3,G9*C3,G9)

the use of the SUM function is wastefull (as there is nothing to sum), as it
is the multiplication by 1.

Regards,
KL


"Niagera College Student" <Niagera College
wrote in message
...
I am a student I Niagera college and am working with excel, I have a n
ifstatmet that is giving the correct answer but its not solving the anser.

The statment : =IF(G9B3,+"sum(G9*C3)",+"sum(G9*1)")

The Answer sum(G9*C3)

The problemi is that it is the wright answer but it will not tally the
sum.

Help me PLZ

Leave out the quotes and the superfluous SUM()s and "+" signs:

=IF(G9B3, G9*C3, G9)

That can then be further simplified to

=G9 * IF(G9B3, C3, 1)



In article ,
"Niagera College Student" <Niagera College
wrote:

I am a student I Niagera college and am working with excel, I have a n
ifstatmet that is giving the correct answer but its not solving the anser.

The statment : =IF(G9B3,+"sum(G9*C3)",+"sum(G9*1)")

The Answer sum(G9*C3)

The problemi is that it is the wright answer but it will not tally the sum.

Help me PLZ

Thank you for you help in the end I was able to make it simple

IF(G9$B$3,H9*$C$3,H9*0)

"JE McGimpsey" wrote:

Leave out the quotes and the superfluous SUM()s and "+" signs:

=IF(G9B3, G9*C3, G9)

That can then be further simplified to

=G9 * IF(G9B3, C3, 1)



In article ,
"Niagera College Student" <Niagera College
wrote:

I am a student I Niagera college and am working with excel, I have a n
ifstatmet that is giving the correct answer but its not solving the anser.

The statment : =IF(G9B3,+"sum(G9*C3)",+"sum(G9*1)")

The Answer sum(G9*C3)

The problemi is that it is the wright answer but it will not tally the sum.

Help me PLZ

Since anything multiplie by zero is zero, you could make it just a bit
simpler:

=IF(G9$B$3,H9*$C$3,0)

Just for kicks, you could also do it this way, since XL interprets a
TRUE value as 1 and FALSE as zero in a math formula:

=H9*$C$3*(G9$B$3)




In article ,
"Niagera College Student"
wrote:

Thank you for you help in the end I was able to make it simple

IF(G9$B$3,H9*$C$3,H9*0)