If Formula

New Contributor

I am trying to figure out the formula for:


If C3 = 0 then D3 = 0 otherwise D3 equals O5/C12*C3

3 Replies

@MahreMahreWolff This assumes the formula takes place in cell D3





Thank you!!!


If C3 is zero then O5/C12*C3 also returns zero, why do you need IF() for that? If to avoid an error when C12 is also zero then better = IFERROR(O5/C12*C3,0)