I'm trying to figure out why my IF formula doesn't work. I want the result to be a blank cell but it gives me FALSE. It is possible for any one (or all) of the multiplied cells to be blank which is why I added the IFERROR to them.
Can anyone give me a pointer?
Can anyone give me a pointer?
Excel Formula:
=IF((IFERROR((J49*D49),0)+IFERROR((J50*D50),0)+(IFERROR(J51*D51,0)))=0,"")