# Using "" in an IFERROR formula

#### SimonHughes

##### Active Member
Hello, I have created a simple formula, IFERROR(B1-A1,"") where the contents of B1 and A1 are formatted as currency, £

There are blank cells in some rows and I wanted to return a blank but the formula returns £0.00. I have solved it using IF(B1>0,B1-A1,"") but I would pfrefer to use IFERROR, any ideas on why it wont work?

I am using Excel 2010

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
If either or both of A1 and B1 are blank then when you use

=B1-A1

that doesn't give an error, the blanks are treated as zeroes

Hi Barry, I still get a rturn of £0.00. As I said, I have solved the problem but I am interested to know why the IFERROR does not work as well.

I think you missed Barry's point..

If A1 and B1 are blank, then B1-A1 is NOT an error, it's just 0.

To see for yourself, put this in a cell
=B1-A1

You'll see it returns 0, not an error when both are blank.
Basically, blanks are treated as 0

So if A1-B1 is NOT an error, then IFERROR will not trap it as an error.

So your solution of IF(B1>0,B1-A1,"") is a reasonable solution.

I did miss the point. Thanks for taking the time to explain, appreciated.

Replies
11
Views
92
Replies
9
Views
430
Replies
12
Views
265
Replies
7
Views
111
Replies
7
Views
290

1,203,462
Messages
6,055,565
Members
444,799
Latest member
CraigCrowhurst

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