# How to use IFERROR in a simple formula

#### noelpahati10

##### Board Regular
Hi All,

I'm using this formula to add a plus sign ="+"&L4.

Example1: A2= 123456789 B2=+123456789
Example2: A3= empty B3= Empty "no plus sign"

If the cell is empty how can I display empty cell with the above formula on it.
Thank you.

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
in B2

=If(A2="", "", "+" & A2)

then drag the formula down the column.

Last edited:
Wow thank you so much for the help tygrrboi

You're welcome.

IFERROR only works if the formula results in an actual error.. not when it results in "undesired results" ="+" & A2 will always be fine even when A2 is blank.. it will just be "+"

If you were to do something that could result in an error, you can use IFERROR to adjust the result for example

=100/A2

If A2 is 50, it will be 2; if A2 is 1 it will be 100... but if A2 is 0, you cannot divide by 0 so you get a result that says #DIV/0!

=IFERROR(100/A2, "That's an imaginary number!!!") will take all the errors resulting in error (in this case... 0) and replace it with something else.

IF formulas need a condition, a value if true and a value if false...
=IF(condition, value if true, value if false)

IFERROR just requires the original formula, and a value if there's an error.

=IFERROR(formula-which will display correctly when there's no error, value if error)

I know you didn't ask but I thought it might be nice to show you why.

You're welcome.

IFERROR only works if the formula results in an actual error.. not when it results in "undesired results" ="+" & A2 will always be fine even when A2 is blank.. it will just be "+"

If you were to do something that could result in an error, you can use IFERROR to adjust the result for example

=100/A2

If A2 is 50, it will be 2; if A2 is 1 it will be 100... but if A2 is 0, you cannot divide by 0 so you get a result that says #DIV/0!

=IFERROR(100/A2, "That's an imaginary number!!!") will take all the errors resulting in error (in this case... 0) and replace it with something else.

IF formulas need a condition, a value if true and a value if false...
=IF(condition, value if true, value if false)

IFERROR just requires the original formula, and a value if there's an error.

=IFERROR(formula-which will display correctly when there's no error, value if error)

I know you didn't ask but I thought it might be nice to show you why.

Thank you so much for enlightening me and sharing good notes about it really appreciate it more power.

Replies
1
Views
444
Replies
4
Views
150
Replies
21
Views
1K
Replies
5
Views
158
Replies
3
Views
297

1,203,046
Messages
6,053,191
Members
444,644
Latest member
keepontruckinc4

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