Problem in Excel

[spotit3]

Can anyone tell me how I can add �500 to a row of figures in Excel say B16 to N16, I think it is something to do wuth Paste Special. All help greatly appreciated.

[tiggerblue10]

I spend most of my working hours on Excel spreadsheets and I can do it quite easily but I can't seem to explain it in writing! Lol

Good job Chucky is here eh :o)

[hippyhoppy]

why don't you both come over - I'll crack open some Akvavit!!

[ChuckFickens]

spotit3, No problem, like I said there are probably other ways of doing it and some may be easier but I'm not an excel expert.

Hippy... and I bet you've not got a spare room at No.30 so I'd have to share eh ;)

[hippyhoppy]

wouldn't have it any other way Chuckie xx ;-)

[weeal]

weeal slinks off un-noticed

[ChuckFickens]

LOL.... sorry al... your reply wasn't there when I started.... I'll work my way north, but have a feeling I may be some time :)

[weeal]

humph

[Yorky Lass]

If you want the total of the row ( B16 to N16 ) to be in O16 try the formula B16:N16,+500

Hope this helps

[ACtheTROLL]

nissed as a wart ... them not me

in your example =sum(b16:n16)+500