IF function #DIV Error between cells in two columns

Question

Hi,I am having a problem trying to return a value in one column when it manages to return 0% in the other.The first line works fine and will return a 0 if there is one present which is what I want and am using&nbsp; the formula&nbsp;=IF(U15,U15/T15*100,0). What I need is some sort of AND, OR type function in the formula so for the lines down it reads column S as well and returns 100% when T is empty.I have tried all sorts of combinations but get Value or Name errors etc. Please help.STUV&nbsp;Actual&nbsp;&nbsp;Budget&nbsp;Variance(%)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 214.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,500-1286.00-86&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;2.50#DIV/0!&nbsp;&nbsp;&nbsp;&nbsp; 7,379.80&nbsp;7379.80#DIV/0!&nbsp;Thank you.Kr, David

sergeibaklan · Answer

Carsmile&nbsp;
That could be
=IFERROR(U15/T15*100,1)

carsmile · Answer

SergeiBaklan&nbsp;&nbsp;Thank you for the quick reply. I will be looking at this again over the next day or so and will let you know how I get on.

Forum Discussion

IF function #DIV Error between cells in two columns

2 Replies

Resources

S	T	U	V
Actual	Budget	Variance	(%)
214.00	1,500	-1286.00	-86
2.50	-	2.50	#DIV/0!
7,379.80		7379.80	#DIV/0!