hi Dorothy,thank you for going to all the bother, I much appreciate your help. I'll give it a go and let you know how I get on.
Susan----- Original Message ----- From: "Dorothy" <dorothy.darke@xxxxxxxxxxxxxx>
To: <vip_students@xxxxxxxxxxxxx> Sent: Wednesday, September 16, 2009 11:22 PM Subject: [vip_students] Re: shortcuts in excel
Hi SusanThere are no short cut keys for doing Subtract, division and Multiplication.Here is the way to do them.Subtract =sum(cell address i.e. a1)-(cell address) enter The second cell address can be a number with out the brackets.Division =sum(cell address)/(cell address) enter The second cell address can be a number with out the bracketsMultiplication =sum(cell address)*(Cell Address) enter The second cell address can be a number with out the bracketsHope this helps Bill, Dorothy's computer trainer.
-- I am using the free version of SPAMfighter. We are a community of 6 million users fighting spam. SPAMfighter has removed 1615 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len The Professional version does not have this message