G Guest Feb 16, 2004 #1 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%?
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 Feb 16, 2004 #2 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%?
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 Feb 16, 2004 #3 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%?
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%?
