Hi,
I would like to auto calculate the remaining credit limit if the cost of the order was £175 abd so on
cost of order credit limit remaining credit
5000
168 4832
200 4800
150 4850
175 =5000-175
168 = 5000-168
120
to cut a long story short, what formula do I use so that excel will also always let me choose the cell which has 5000 inside it? I thought i would use the $ sign ??
Hope thats clear?
pls helo
I would like to auto calculate the remaining credit limit if the cost of the order was £175 abd so on
cost of order credit limit remaining credit
5000
168 4832
200 4800
150 4850
175 =5000-175
168 = 5000-168
120
to cut a long story short, what formula do I use so that excel will also always let me choose the cell which has 5000 inside it? I thought i would use the $ sign ??
Hope thats clear?
pls helo
