Excel 2003 should have "multiply multiple cells" macro / shortcut
 

Why cant there be a function that will multiply several highlighted cells
with a simple click, like Sigma does for addition?

Many times I need to multiply 2 to 4 adjacent cells together and I have to
write the formula. I want to be able to highlight the 2 to 4 adjacent cells
and click a button that means multiply these together. Just like the "sigma"
or Sum function only for multiplication.

Anyone have suggestions or comments?




----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

Excel 2003 should have "multiply multiple cells" macro / shortcut
 

In the Sigma Dropdown, Choose more functions and Choose product

--
Regards,
Tom Ogilvy


"Tommy D" <Tommy wrote in message
...
Why cant there be a function that will multiply several highlighted cells
with a simple click, like Sigma does for addition?

Many times I need to multiply 2 to 4 adjacent cells together and I have to
write the formula. I want to be able to highlight the 2 to 4 adjacent
cells
and click a button that means multiply these together. Just like the
"sigma"
or Sum function only for multiplication.

Anyone have suggestions or comments?




----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...el.programming