I might not be explaining it correctly...any help?
2) What variables do you want to manipulate (be able to change)........... the percentage, the values, or both?
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.
=(B4*.085)+B4
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.
DrMaddVibe wrote:
=((B2*(T1*.5))+T1B2 = "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.
=((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.
Formula in Cell E4
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"
Oh, just multiply by 1.085
=B4*1.085
that's weird - works fine for me
You cannot have the formula in B4
Excel 2013?
No - an ancient Mac version - but it shouldn't matter on a formula this simple
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?
=(E4*F4)+G4
??
Amount..........Tax.............Total
Correct...yet I'm working within a created worksheet and cannot add more columns.
8.5%
Same answer...
Should'nt it be
=(E4*F4)+E4
where E4=450
F4 = .085
and G4 has my formula above
OMG....yes...Thank you!
God, my brain hurts!