Hi
I'm a complete excel novice and could do with a little help if you can. as you can see pic its a really simple document.
The formula im after is to go in the 'Variance' field, I want it so that if there is no amount in the 'Actual' field, it displays 0. So in the pic above, the 1st 2 amounts are correct, bu tthe 3rd down should show £0 not -£2000
The formula in there at the moment is =SUM(E4)-D4
I'm a complete excel novice and could do with a little help if you can. as you can see pic its a really simple document.
The formula im after is to go in the 'Variance' field, I want it so that if there is no amount in the 'Actual' field, it displays 0. So in the pic above, the 1st 2 amounts are correct, bu tthe 3rd down should show £0 not -£2000
The formula in there at the moment is =SUM(E4)-D4
