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
3 Replies
Sort By
- SergeiBaklanDiamond 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)
- adversiIron Contributor
- MahreMahreWolffCopper Contributor