G Guest Nov 8, 2006 #1 How do I add a formula to find 15% of an amount? The amounts are listed in column D. I want to see 15% in Column E
How do I add a formula to find 15% of an amount? The amounts are listed in column D. I want to see 15% in Column E
B Bob Phillips Nov 8, 2006 #3 On the off-chance that the 15% is included in the amount, you can use =A1*(1-1/1.15) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
On the off-chance that the 15% is included in the amount, you can use =A1*(1-1/1.15) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
