Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
secarter
 
Posts: n/a
Default How do I Multiply different cells by one number as a formula?

I have to two clients and need to show that I'm multiplying their total
charge by half. I am using a template for the first time and need to know
how to do that so my clients can see the formula? Help I haven't done this
since college and i'm a little rusty.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
peabrain25
 
Posts: n/a
Default How do I Multiply different cells by one number as a formula?

If this is what you would like to show, you could just put the charge in the
Column B, the phrase 'x 0.5 =' in the Column C and the formula =B1*0.5 in
Column D.

A B C D

Client 1 $100.00 x 0.5 = $50.00
Client 2 $100.00 x 0.5 = $50.00


Hope this helps!
Mark

"secarter" wrote:

I have to two clients and need to show that I'm multiplying their total
charge by half. I am using a template for the first time and need to know
how to do that so my clients can see the formula? Help I haven't done this
since college and i'm a little rusty.

  #3   Report Post  
Posted to microsoft.public.excel.newusers
secarter
 
Posts: n/a
Default How do I Multiply different cells by one number as a formula?

That helps..but i'm using a template that only gives me

charges credits total

so there is only three colums to work with. any other help would be
appreciated.

thanks


"peabrain25" wrote:

If this is what you would like to show, you could just put the charge in the
Column B, the phrase 'x 0.5 =' in the Column C and the formula =B1*0.5 in
Column D.

A B C D

Client 1 $100.00 x 0.5 = $50.00
Client 2 $100.00 x 0.5 = $50.00


Hope this helps!
Mark

"secarter" wrote:

I have to two clients and need to show that I'm multiplying their total
charge by half. I am using a template for the first time and need to know
how to do that so my clients can see the formula? Help I haven't done this
since college and i'm a little rusty.

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
Formula for counting number of cells Pawan Excel Discussion (Misc queries) 2 February 22nd 06 05:20 AM
Return SEARCHED Column Number of Numeric Label and Value Sam via OfficeKB.com Excel Worksheet Functions 23 January 30th 06 06:16 PM
formula in excel to skip cells having - number and add only + anthonylaw Excel Worksheet Functions 3 October 25th 05 06:46 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM


All times are GMT +1. The time now is 09:55 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"