Returning a zero if data is not ready.

[brummingham]

I wonder if anyone can help me please.

In cell H5 I have the following formula =(G5-E5)/E5. However if G5 is 0 I want to return 0 in H5. Then when G5 gets populated the formula can continue.

Regards.

[mikeava]

Try this in H5

=IF(G5=0,0,(G5-E5)/E5)