ISBlank when the cell contains a formula

[sunshinereel2]

Need some assistance. Need to have this formula return a " " if there is not a quanity(number) in the cell being referenced. However, the cell being referenced has a formula in it to return needed results so I get a value error. Is there a better way to complete this?

=IF(ISBLANK(M87)," ",M87*N87) is in cell P87

In cell M87 is a formula that is =D87

D87 result is dependent on what is selected in Cell A74.

Any help would be greatly appreciated and please let me know if you have a question to clarify what I am asking.

Thank you and I appreciate your time.

 

[Tetra201]

Try this:

=IF(AND(ISNUMBER(M87),ISNUMBER(N87)),M87*N87," ")

 

[godsaaint]

Instead of using isblank, you could also say: M87=""

 

[Scott Huish]

You generally don't want to return a space to indicate blank, use an empty string ""

Does this work for you?

=IF(COUNT(M87:N87)=2,M87*N87,"")

 

[sunshinereel2]

Thank you this worked! Appreciate your time and help!

 

[sunshinereel2]

I actually did try that along with M87="0"

 

[sunshinereel2]

You generally don't want to return a space to indicate blank, use an empty string ""

Does this work for you?

=IF(COUNT(M87:N87)=2,M87*N87,"")

This worked as well. Thank you for your time, it is appreciated.

 

[sunshinereel2]

Thank you this worked! Appreciate your time and help!

Try this:

=IF(AND(ISNUMBER(M87),ISNUMBER(N87)),M87*N87," ")

 

[sunshinereel2]

This formula worked however when I drag to copy cell P90 does not calculate as the others do. Thoughts?

You generally don't want to return a space to indicate blank, use an empty string ""

Does this work for you?

=IF(COUNT(M87:N87)=2,M87*N87,"")

 

[Scott Huish]

Do the two cells actually contain a number?
Is it possible that you are returning a number in quotes (which makes it text) via formula?