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

=IF(C3=0,0,O5/C12*C3)

 

@adversi 

 

Thank you!!!

@MahreMahreWolff 

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)