Having a hard time to get rid of the red triangle ...

Assuming this is similar to your situation:

D2=B2÷C2

which occurs because and empty cell returns the value zero

you can solve this by:

1) ignore it OR

2) use the formula

=iferror(B2÷C2, "")

OR

3) use the formula

if(C2 = 0, "", B2÷C2)

The following example will work -- if B3 is not equal to zero then B2/B3 else blank. In Numbers this would be:

IF(B3≠0,B2÷B3,"")

change the formula you have:

=C6 / D6 * E6

to:

=if(D6 = 0, "", C6 / D6 * E6)

based looking at your post, you are in a local where the comma is used as the decimal. therefore, you should use the formula:

=if(D6 = 0; ""; C6 / D6 * E6)

In this minor change, then argument separators in the formula I posted was the comma, but for you should be the semicolon.

Your formula: F6: =C6/D6*E6

Will produce a division by zero error if either of D6 or E6 is zero.

You can use either of these:

F6: =IF(OR(D6=0,E6=0),"",C6/D6*E6)

F6: =IFERROR(C6/D6*E6,"")

The first has the advantage of handling only this specific error. If there are others, IFERROR won't let you see the error triangles that tel you something's wrong.

The second has the advantage of being simpler to write (and to read) If the formula is working fine when neither D6 nor E6 is zero, use it, and fill it into all cells in column F that need this formula.

Regards,

Barry

Oops!

Just looked at it again and realised C/D is completed by the time Numbers even notices E, so C/D*E with any number value in C will work without an error.

Barry

With the typo (or momentary distraction), that certainly cleared things up! (not)

Here's the corrected version...

C/D is completed by the time Numbers even notices E, so C/D*E with any number value in E will work without an error (provided C is not zero).

B