May 10 2022 09:55 AM
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.
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! |
Thank you.
Kr, David
May 10 2022 10:32 AM
May 12 2022 07:40 AM
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.