Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do i multiply a cell by %

i would like to know, how i multiply a cell by %?

ex: 8.41% x $134.70? ( i want to use a formula)
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default how do i multiply a cell by %

Why not =8.41%*A1 ?
--
David Biddulph

"sanz" wrote in message
...
i would like to know, how i multiply a cell by %?

ex: 8.41% x $134.70? ( i want to use a formula)



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default how do i multiply a cell by %

hi,
that would be .0841 * 134.70. if 134.70 was in cell a1, the formula would be
=.0841*A1.

Regards
FSt1

"sanz" wrote:

i would like to know, how i multiply a cell by %?

ex: 8.41% x $134.70? ( i want to use a formula)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% George A. Yorks Excel Discussion (Misc queries) 10 October 25th 06 09:45 PM
How do you multiply each cell by the same number? ( 899.80*.085) Shanon Excel Discussion (Misc queries) 2 March 20th 06 09:27 PM
How do I multiply cell value by percentage? Kelly P. Excel Worksheet Functions 4 October 27th 05 07:27 PM
multiply the value of a cell bruce pinkos Excel Worksheet Functions 1 September 16th 05 02:16 PM
how can i multiply a number in each cell? jay Excel Discussion (Misc queries) 3 February 3rd 05 04:52 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"