Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|