Forum Discussion
Solved
Solving nested if sum calculator for checkbox tasks
Hello ! Can anyone solve the error in this equation ? I can't see it... Would greatly appreciate any questions or solutions. =sum((IF(G2=TRUE, =SUM(D2/1000*9),0))+(IF(H2=TRUE, 1, 0))+(IF(I2=...
Perhaps you mean
=SUM( IF( G2=TRUE, SUM(D2/1000*9),0) + IF( H2=TRUE, 1, 0) + IF( I2=TRUE, 1, 0) + IF( J2=TRUE, 1, 0) + IF( K2=TRUE, 1, 0) + IF( L2=TRUE, 1, 0) )or if to simplify
= IF( G2, D2/1000*9,0) + H2 + I2 + J2 + K2 + L2or
= IF( G2, D2/1000*9,0) + SUM( 1*H2:L2 )
Perhaps you mean
=SUM(
IF( G2=TRUE, SUM(D2/1000*9),0) +
IF( H2=TRUE, 1, 0) +
IF( I2=TRUE, 1, 0) +
IF( J2=TRUE, 1, 0) +
IF( K2=TRUE, 1, 0) +
IF( L2=TRUE, 1, 0)
)or if to simplify
= IF( G2, D2/1000*9,0) + H2 + I2 + J2 + K2 + L2or
= IF( G2, D2/1000*9,0) + SUM( 1*H2:L2 )
Awesome
