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