percentage in excel
Hi there,
Welcome to Excel.
I'll take you through this step by step so you understand fully. We will
use three cells to complete your calculation.
In A1 in put 22.50. In B1 input 3.9. In C1 this is the formula which will
give you the total sales figure less 3.9%.
=A1-(A1*B1%)
It should be pretty self explanatory, but if not please ask again.
--
Russell Dawson
Excel Student
Please hit "Yes" if this post was helpful.
"donnah1234" wrote:
hi i'm new to excel.
i need to know have to do a formula for percentage.
example:
total sales £22.50
i need to subtract 3.9% from total sales
any help would be great
|