# Help with formula

• I have created a formula in column E based on the contents of column C. Cells with a blank in column C should return a blank in Column E. This works for most but E17 returns a negative number instead of a blank. The same happens in E26 and E33. Something must be configured wrong but I can't figure it out. Any help? Thanks.

## Files

• Thanks Mario. When I use this the negative results in E17 goes to blank which is great but the results in E13, E18, E19 and E44 now return a value error.

• Hi

You have to adapt the formulas like these:

in E11 =SE(C11="";"";SE.ERRORE(\$F\$2*(C11-\$I\$2);"" )) and copy to E19

in E23 =SE(C23="";"";SE.ERRORE(\$F\$3*(C23-\$I\$3);"" )) and copy to E27

in E31 =SE(C31="";"";SE.ERRORE(\$F\$4*(C31-\$I\$4);"" )) and copy to E45

Hi,

Mario

• Try

In E11, formula copied down :

=IF(C11="","",IFERROR(INDEX(F\$2:F\$4,LOOKUP(9,MATCH(B\$1:B11,E\$2:E\$4,0)))*(C11-INDEX(I\$2:I\$4,LOOKUP(9,MATCH(B\$1:B11,E\$2:E\$4,0)))),""))

Edited 3 times, last by bosco_yip ().

• Thanks Bosco, that works perfectly. Thanks also to Roy and Mario for their help.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!