What formula do I use to deduct £20 a month from £500 over a year

[Anderson10304]

Hello All,

Can anyone tell me what formula I use to deduct £20.00 from £500 over 12 months the sum I've used is =SUM(500-E18:P18).

So the sum is £500 - my range is E18:P18 the idea is that in january £20 is deducted the whole amount is then reduced to £480.00 and then february a further £20.00 is reduced from the whole amount leaving £460.00 and so on.

My sum is bringing back a #VALUE! when executed.

I hope this makes some sense any advice would be much appreciated.


Regards


Marco







[/FONT]

[Limor_OP]

Hi,
Can you upload in Excel?

[Anderson10304]

Hi,
Can you upload in Excel?

Thanks very much it's now been solved.

[olga6542]

I think your syntax is wrong. Try =500-(SUM(E18:P18))

[Anderson10304]

Hello

Many thanks for your help the formula if I can call it that has worked with your help thank you very much.

When you say (syntax) could you briefly explain if you have a moment, what was wrong with mine for future references.

Thank you

[Anderson10304]

I think your syntax is wrong. Try =500-(SUM(E18:P18))

Hello

Many thanks for your help the formula if I can call it that has worked with your help thank you very much.

When you say (syntax) could you briefly explain if you have a moment, what was wrong with mine for future references.

Thank you

[torachan]

in C2 =B$2-$A$2 copied accross

[Anderson10304]

Thanks very much it's now been solved.

[Anderson10304]

in C2 =B$2-$A$2 copied accross

Thanks very much it's now been solved.