#VALUE error

[Bedford]

need help, in cell D19 I have the following formula; =IF(Entry!C3=0,"",'Calculations and Data'!I13), works perfectly for my needs

In cell E19 I have the formula; =(C10-180)/D19-1 which returns a #VALUE error if D19 is without a result? How can I eliminate the error?

 

[Cubist]

It's because you're dividing by the "". What do you want to return when D19 is blank?

 

[Bedford]

It's because you're dividing by the "". What do you want to return when D19 is blank?

Hoping to return a blank cell.

 

[Cubist]

Hoping to return a blank cell.

You can add IFERROR to account when that happens. Try:

=IFERROR((C10-180)/D19-1,"")

 

[Bedford]

You can add IFERROR to account when that happens. Try:

=IFERROR((C10-180)/D19-1,"")

You're a genius! Thank you!

 

[Peter_SSs]

You're a genius! Thank you!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.