Feb 04 2021 02:37 PM
I am trying to figure out the formula for:
If C3 = 0 then D3 = 0 otherwise D3 equals O5/C12*C3
Feb 04 2021 02:39 PM
Feb 05 2021 11:55 AM
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)