xcel Q
31 July 2011, 03:03 PM
#1
Scooby Regular
Thread Starter
Join Date: Jul 2005
Posts: 12,329
Likes: 0
Received 0 Likes
on
0 Posts
xcel Q
I have a value in excel A1 £100
and i need to take three other cells away from the value of A1
A2 £20
A3 £40
A4 £50
this should give a negative value of -£10
however excel refuses to allow the formula..
Any ideas?
Its vital it shows a negative balance
Mart
and i need to take three other cells away from the value of A1
A2 £20
A3 £40
A4 £50
this should give a negative value of -£10
however excel refuses to allow the formula..
Any ideas?
Its vital it shows a negative balance
Mart
cheers .. 
Thread
Thread Starter
Forum
Replies
Last Post