Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|