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.
Help with formula
-
-
Hello
Try this
=IF(C17>0;$F$2*(C17-$I$2);"")
Hi,
Mario
-
Display More
Hello
Try this
=IF(C17>0;$F$2*(C17-$I$2);"")
Hi,
Mario
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)))),"")) -
-
I would also suggest that you do not add IFERROR until you know the formulas are working as expected.
-
Display More
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)))),""))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!
