IF(ISERROR

[ozbeachbum]

I have a formula [=IF(ISERROR((B3/B4)),0,((B4-B3)/B4))] that returns the correct percentages for Columns B & F, but not D.
I need to adjust it so that results in B & F show as is and where D4 equals ZERO no matter what the amount in D3 is, the percentage for D2 would always be 100%.

EG: B 0.00% D 100.00% F 50.00%

Thanks in advance for any assistance.

241106 if error.xlsx
	B	C	D	E	F
2	0.00%		0.00%		50.00%
3	$ -		$ 0.50		$ 0.50
4	$ -		$ -		$ 1.00
5
6			100.00%
Blank

Cell Formulas
Range	Formula
B2,F2,D2	B2	=IF(ISERROR((B3/B4)),0,((B4-B3)/B4))

 

[Peter_SSs]

OK. Then how about:
=IF(AND(B4,B4+B3),ABS((B4-B3)/B4),--OR(B3))

Seems to work fine to me but I don't see any advantage to the simpler one (to me) in post 7.

I do note that our formulas can give different results in some circumstances but we don't actually know what is possible/impossible with the OP's data, so unless we hear of a problem it doesn't matter as far as I can see.

 

[ozbeachbum]

Thank you Phuoc; Peter and Scott, really appreciate the time and effort you put in to help us dummies.
I have marked Phuoc's as the correct answer as it was correct for the information I provided originally.
For my amended post, Peter yours works as does both of Scott's.
More than one way to skin a cat as the saying goes.
Cheers, to all three for your help.
Dave.

 

[Peter_SSs]

Cheers. Glad we could help. Thanks for the follow-up.