Help with Formula that will return a blank cell if another cell in formula is blank.

[Jalayne]

I'm needing help with adding to the below formula so that if "Estimated Sales" or "PoP Duration" is blank than "Estimated Sales Per Day" comes out blank as well.

Here is what I have (it's pretty basic): =[@[Estimated Sales]]/[@[PoP Duration (Days)]]

I included a pic of my spreadsheet if that helps (Formula is for "Estimated sales per Day" column)

Thanks in Advance!

 

[Fluff]

How about

=IF(OR([@[Estimated Sales]]="",[@[PoP Duration (Days)]]=""),"",[@[Estimated Sales]]/[@[PoP Duration (Days)]])

 

[Jalayne]

How about

=IF(OR([@[Estimated Sales]]="",[@[PoP Duration (Days)]]=""),"",[@[Estimated Sales]]/[@[PoP Duration (Days)]])

Still gives me the "#DIV/0!" Error.

 

[Jalayne]

Still gives me the "#DIV/0!" Error.

Maybe it has something to do with PoP Duration being "0" and not blank? I just realized that because of the formula i have in "PoP Duration" it will always be at least "0" so maybe the error has something do to with that.

 

[Fluff]

That's because the cells aren't blank.
Try

=IFERROR([@[Estimated Sales]]/[@[PoP Duration (Days)]],"")

 

[Jalayne]

That's because the cells aren't blank.
Try

=IFERROR([@[Estimated Sales]]/[@[PoP Duration (Days)]],"")

Worked perfect! Thanks!

 

[Fluff]

You're welcome & thanks for the feedback.