calculating a variable percentage?

D

dparker

After losing my hard drive to the Blue Screen of Death, I'm trying t
recreate scratch quote sheets that the employee before me had created
The idea is that I should be able to fill in:

*the cost of an item in column A,
*additional charges in cloumn B,
*the net price in column C (A and B added together)
*and a sell price in column D, which is a variable percentage multiple
by column C.

I know this is easy basic stuff, but I don't have a clue with Excel
want to be able to fill in a percentage in column D which wil
automatically multiply itself with column C, ergo giving me the sel
price, but I can't figure out the formula for column D (I'm clear o
the rest of it). Does this make any sense? I really appreciate any hel
that you can offer
 
N

Norman Harker

Hi DParker!

=C1*(1+15%)

But better to put your percentage in a cell and refer to that.

If using a variable percentage based upon criteria, you might use a
VLOOKUP to get the percentage from a table.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top