LinkBack URL
About LinkBacks
Hi, I'm tring to multiply all those values in the cells coloured yellow. It takes time to use a calculator..I need o code/formulla that will multiply the value in each/every cells I click and display the result in "H1"
Hi, I'm tring to multiply all those values in the cells coloured yellow. It takes time to use a calculator..I need o code/formulla that will multiply the value in each/every cells I click and display the result in "H1"
Last edited by gencoglu27; 09-27-2011 at 03:16 PM.
As I cannot see any logical use of the yellow shading, the best I can subscribe is to start with = and then click on each cell, followed by * then the next cell, etc then ENTER. Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Re: multiplying
Yes, I tried as you described..holding CTRL.. yes it worked.. I didn't know CTRL will be of use..
Thanks..SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks