Forum Discussion
MahreMahreWolff
Feb 04, 2021Copper Contributor
If Formula
I am trying to figure out the formula for: If C3 = 0 then D3 = 0 otherwise D3 equals O5/C12*C3
SergeiBaklan
Feb 05, 2021Diamond Contributor
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)