# ISBlank when the cell contains a formula

#### sunshinereel2

##### New Member
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.

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

#### Tetra201

##### MrExcel MVP
Try this:

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

#### godsaaint

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

#### Scott Huish

##### MrExcel MVP
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

##### New Member
Thank you this worked! Appreciate your time and help!

#### sunshinereel2

##### New Member
I actually did try that along with M87="0"

#### sunshinereel2

##### New Member
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

##### New Member
Thank you this worked! Appreciate your time and help!

Try this:

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

#### sunshinereel2

##### New Member
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

##### MrExcel MVP
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?

Replies
6
Views
157
Replies
5
Views
139
Replies
3
Views
125
Replies
14
Views
283
Replies
9
Views
233

1,190,564
Messages
5,981,704
Members
439,731
Latest member
auraitsuka

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back