ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I Multiply different cells by one number as a formula? (https://www.excelbanter.com/new-users-excel/76042-how-do-i-multiply-different-cells-one-number-formula.html)

secarter

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.

peabrain25

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.


secarter

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.



All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com