DrMaddVibe
Sunday, September 28, 2014 1:08:21 PM
I need to insert a formula that multiplies the amount of one cell with the percentage of another and then add the product to the same cell.

I might not be explaining it correctly...any help?

KingoftheCove
Sunday, September 28, 2014 1:33:24 PM
1) Is the "percentage of another" simply a percentage, or a percentage of a second value?

2) What variables do you want to manipulate (be able to change)........... the percentage, the values, or both?

DrMaddVibe
Sunday, September 28, 2014 1:51:33 PM
I have a dollar amount and a taxed percent amount in 2 cells in 2 columns

Say 450.00 in B4 and a taxed amount...8.5% in C4...Cell D4 would contain the total, but I need the grand total of 450*8.5% and then added together.

KingoftheCove
Sunday, September 28, 2014 1:56:56 PM
Formula in Cell E4

=(B4*.085)+B4

Gene363
Sunday, September 28, 2014 2:04:32 PM

I need to insert a formula that multiplies the amount of one cell with the percentage of another and then add the product to the same cell.

I might not be explaining it correctly...any help?

DrMaddVibe wrote:

=((B2*(T1*.5))+T1

B2 = "multiplies the amount of one cell "

Use (T1*.5) where the T1 is the other cell and .5 is the the percentage, in this case 50%.

Or you can reference a cell, e.g. $a$3, in each formula, with the percent value and change it in one place, A# in this example. Say the percentage is in cell A2 and use (T1*$A$2) The dollar signs in a formula will maintain the reference to that cell as you copy the formula.

DrMaddVibe
Sunday, September 28, 2014 2:05:04 PM

Formula in Cell E4

=(B4*.085)+B4

KingoftheCove wrote:

It kicks an error message. What you put was what I was thinking too.

It says "Careful we found one or more circular references in your workbook that might cause your formulas to calculate incorrectly"

Gene363
Sunday, September 28, 2014 2:08:16 PM

Oh, just multiply by 1.085

=B4*1.085

KingoftheCove
Sunday, September 28, 2014 2:08:48 PM

It kicks an error message. What you put was what I was thinking too.

It says "Careful we found one or more circular references in your workbook that might cause your formulas to calculate incorrectly"

DrMaddVibe wrote:

that's weird - works fine for me

DrMaddVibe
Sunday, September 28, 2014 2:09:09 PM
Excel 2013?
KingoftheCove
Sunday, September 28, 2014 2:10:41 PM
you are using parenthesis right??
Gene363
Sunday, September 28, 2014 2:10:59 PM

You cannot have the formula in B4

KingoftheCove
Sunday, September 28, 2014 2:12:38 PM

Excel 2013?

DrMaddVibe wrote:

No - an ancient Mac version - but it shouldn't matter on a formula this simple

DrMaddVibe
Sunday, September 28, 2014 2:14:09 PM
Yes to both
KingoftheCove
Sunday, September 28, 2014 2:16:58 PM
try removing the parens.......just for fun.....answer should be the same......works for me
KingoftheCove
Sunday, September 28, 2014 2:21:54 PM
Amount..........Tax.............Total

450...............0.085..........488.25

Is this want you want top end up with, where the Total is Original amount (450) added to 8.5% of 450?

DrMaddVibe
Sunday, September 28, 2014 2:25:51 PM
Same answer...

=(E4*F4)+G4

??

DrMaddVibe
Sunday, September 28, 2014 2:27:04 PM

Amount..........Tax.............Total

450...............0.085..........488.25

Is this want you want top end up with, where the Total is Original amount (450) added to 8.5% of 450?

KingoftheCove wrote:

Correct...yet I'm working within a created worksheet and cannot add more columns.

8.5%

KingoftheCove
Sunday, September 28, 2014 2:34:46 PM

Same answer...

=(E4*F4)+G4

??

DrMaddVibe wrote:

Should'nt it be

=(E4*F4)+E4

where E4=450

F4 = .085

and G4 has my formula above

DrMaddVibe
Sunday, September 28, 2014 2:37:25 PM

Should'nt it be

=(E4*F4)+E4

where E4=450

F4 = .085

and G4 has my formula above

KingoftheCove wrote:

OMG....yes...Thank you!

God, my brain hurts!

wvwa34
Sunday, September 28, 2014 3:47:32 PM
Numbers in ,numbers out,,, numbers that are false,,,numbers you wish to have,,numbers that are realistic..... pretty simple!!!1