![]() |
Formula Help
how do I wrtie a formula that will times a number by a percentage and give me
a greater reult? For example if I have 100 in cell A1 and 5% (my increase over 100) in B1 and I want a formula to show me 105% of A1 how would this look? Thanks |
Formula Help
Hi,
A1 = 100 b1 = 5% In c1 =A1+A1*B1 Mike "Jim" wrote: how do I wrtie a formula that will times a number by a percentage and give me a greater reult? For example if I have 100 in cell A1 and 5% (my increase over 100) in B1 and I want a formula to show me 105% of A1 how would this look? Thanks |
Formula Help
=A1*(1+B1)
-- David Biddulph Jim wrote: how do I wrtie a formula that will times a number by a percentage and give me a greater reult? For example if I have 100 in cell A1 and 5% (my increase over 100) in B1 and I want a formula to show me 105% of A1 how would this look? Thanks |
All times are GMT +1. The time now is 10:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com