IFERROR problem

[brianaclark1967]

Hi all,

I'm tring to add an iferror to the formula below

=O120-N117-(($N$2/$N121)*S114)

I wan't to avoid getting #DIV/0! in the result

I would rather return a zero if there's an error, instead #DIV/0!

Regards,

Brian

 

[Derek McGill]

Try :-
=IF(ISERROR(O120-N117-(($N$2/$N121)*S114)),"0",O120-N117-(($N$2/$N121)*S114))

 

[brianaclark1967]

Hi Derek,

That worked a treat. Thank you so much.
Much appreciated.

kind regards,

Brian

 

[brianaclark1967]

Hi Derek,

Would you be able to add the same iferror to the formula below please.

I've tried doing it based on the earlier one you sent, but can't seem to get it to work

=SUM(($N115+$N116)/$N120)*$J114

Regards

Brian

 

[AVK]

Hi all,

I'm tring to add an iferror to the formula below

=O120-N117-(($N$2/$N121)*S114)

I wan't to avoid getting #DIV/0! in the result

I would rather return a zero if there's an error, instead #DIV/0!

Regards,

Brian

Dear Brian
I think your formula not get corrected result. Can you attach your file. What data show in
O120, N117, N2:N121 & S114
If In O120 is 1000
In N117 is 100
In N2 is 10 & N121 is 2 (10/2=5)
In S114 is 2
=1000-100=900
=900-5 = 895
=895*2= 1790
Asper your formula get result is : 890
kindly confirm.

 

[Derek McGill]

Try
=IF(ISERROR(SUM(($N115+$N116)/$N120)*$J114),"0",SUM(($N115+$N116)/$N120)*$J114)

 

[Derek McGill]

The way it works is :-
=IF(ISERROR(Your Formula here),"What you want to see on error",Your Formula here)

 

[Speedy Sam]

You may also be able to use:

IFERROR(Value if no error, value if error)

for example:

IFERROR(SUM(($N115+$N116)/$N120)*$J114,0)

 

[Khalid NGO]

IFERROR(SUM(($N115+$N116)/$N120)*$J114,0)

Hi Sam,

SUM is not necessary

1)
=IFERROR((($N115+$N116)/$N120)*$J114,0)

2)
=IFERROR(($N115+$N116)/$N120*$J114,0)

Regards,

 

[Speedy Sam]

Agreed