Thread: Help
View Single Post
  #2   Report Post  
KL
 
Posts: n/a
Default

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