Add 10% to an amount.
Solved
tos51
-
Ricky38 Posted messages 5776 Registration date Status Contributor Last intervention -
Ricky38 Posted messages 5776 Registration date Status Contributor Last intervention -
Hello,
In my Excel spreadsheet, I would like to add 10%. Let me explain, I employ a person and I would like to add 10% to their net salary in my table.
I tried using formulas unsuccessfully. It always shows the percentage of the amount.
I'm using Excel 2003.
Thank you for your help.
Configuration: Windows XP / Firefox 3.6.18
In my Excel spreadsheet, I would like to add 10%. Let me explain, I employ a person and I would like to add 10% to their net salary in my table.
I tried using formulas unsuccessfully. It always shows the percentage of the amount.
I'm using Excel 2003.
Thank you for your help.
Configuration: Windows XP / Firefox 3.6.18
2 answers
Different command lines used.
=A1*1.1
=A1+ ((A1*10)/100)
=A1+(A1*0.1)
And the result is always in %, but my concern is that I need to add daily allowances on top of it. So with the result in %, I can't add anything anymore.
Hoping I was clear enough; if not, feel free to ask me for more information.
Thanks in advance for your help.
=A1*1.1
=A1+ ((A1*10)/100)
=A1+(A1*0.1)
And the result is always in %, but my concern is that I need to add daily allowances on top of it. So with the result in %, I can't add anything anymore.
Hoping I was clear enough; if not, feel free to ask me for more information.
Thanks in advance for your help.