calcualtion help

  • Thread starter Thread starter Justin
  • Start date Start date
J

Justin

I have 3 columns
A1 = 500
B1 = % (will be a variable value I input)
C1 = result

The goal here is for a calculation that takes 500, multiplies it by the
percentage (say 10%), and presents me with a result of 450 (in the 10%
example).

This might be easy for you but I am all balled up.

Can you help?

Thanxs
 
Hi Justin!

Try:
=A1*(1-B1)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Justin
if B1 is a percentage value enter the following in C1
=A1-A1*B1
or
=A1*(1-B1)

Frank
 
Back
Top