The reason this happens is because of your IF statement in P. If there is no data, the formula returns "". While it may look like a blank cell, Excel doesn't treat it the same and any formula that uses it as an operator will result in an error when it is blank.



There are a few ways to get around this. The easiest is to modify your equation as I mentioned above:

=iferror(((round(m28,0)-round(o28,0))*p28),"")

Hi. I put in the calculation you provided. Everything works great except for R28. I'm not sure why it's not working. I don't get the issue on any of the other cells. It's a mystery. Do you have any ideas why this would happen? Thanks for your help in advanced.

Sure do. If you expand the formula bar, you will see that you seem to have pasted the equation in there twice.

Just copy the cell below and paste it there. Problem solved.

You are too smart! Thank you so much. This works perfect now. I appreciate your help.

Gebobs' solution is the way to go or use =IF(M28,0.56,0) in col P and hide the 0 if needed. Also beware of merged cells ( col P and Q) they are nothing but trouble.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post