How to use IFERROR in a simple formula

[noelpahati10]

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.

 

[tygrrboi]

in B2

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

then drag the formula down the column.

 

[noelpahati10]

Wow thank you so much for the help tygrrboi

 

[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.

 

[noelpahati10]

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.