How to correct a #DIV/0! error when I have multiple cells being used

Question

I have tried all of the solutions offered to me by the "Help" function and I still cannot figure out how to correct my error. I am trying to not show anything in the cell that shows my end calculations unless the other 3 fields are usable for the calculations. 

I am using the following formula to calculate my cell:

=(S4-V4)/Y4

The result comes up and gives me the dreaded "#DIV/0" Error, and I cannot get it to just show a blank cell.

Please help me

Shocker

Answer 1

To avoid #DIV0! when Y4 is empty

=IF(Y4<>0,(S4-V4)/Y4,"")

or

 IFERROR((S4-V4)/Y4,"")

To perform the calculation only when the three cells have numeric value

=IF(COUNT(S4,V4,Y4)=3,(S4-V4)/Y4,"")

best wishes

Answer 2

So, I do need to show a value in this cell "AB--" if there are actually numeric values in the "S", "Y" and "V" cells. I have actually tried all 3 of these proposed solutions, and neither of them seemed to work for what I need to happen there. Looking at the picture that I have posted, I need for the cells labeled "PCT", not to show anything unless the cell has something to get the calculations from. They are being tabulated using the following formulas:

Attack Percentage = [ ( K - E ) / TA ]

These cells are the following cells:

Attack Percentage = PCT = Cells "AB"

K = Kills = Cells "S"

E = Errors = Cells "V"

TA = Total Attempts = Cells "Y"

So the excel formula that I have used is:

=(S4-V4)/Y4

This calculates perfectly when I have data in the cells but still continues to give me the #"DIV/0! error.

Answer 3

My formula is as follows:

=(E10+F10)/D10 and I get the #DIV/0! error.

I've tried the fix above and it's not working.

Suggestions?

Answer 4

Use =IFERROR((E10+F10)/D10,"")

BEST WISHES