IF function #DIV Error between cells in two columns

Copper Contributor

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  the formula 

=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
 Actual  Budget Variance(%)
        214.00          1,500-1286.00-86
            2.50               -  2.50#DIV/0!
     7,379.80 7379.80#DIV/0!

 

Thank you.

Kr, David

2 Replies

@Carsmile 

That could be

=IFERROR(U15/T15*100,1)

@Sergei Baklan 

 

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.