Decrease by percent

J

JBrown

To increase a number by a certain percent (for instance, 3%) I multiply the number by 1.03. How about if I want to decrease the number by 3%?
 
F

Frank Kabel

Hi
try
=A1*0.97
or
=A1-(A1*(percent_value/100)) -> =A1-(A1*(3/100))

--
Regards
Frank Kabel
Frankfurt, Germany
JBrown said:
To increase a number by a certain percent (for instance, 3%) I
Click to expand...
multiply the number by 1.03. How about if I want to decrease the number
by 3%?
 
G

Guest

multiply by 97%
-----Original Message-----
To increase a number by a certain percent (for instance,
Click to expand...
3%) I multiply the number by 1.03. How about if I want to
decrease the number by 3%?
 
Top