Good morning
I have a cell that is populated with a result from various other cells, I have another cell that is formatted as % which will contain a variable number set by the airlines each month, currently 11% in another cell I would like to add the percentage to get a true total. At the moment I am using for example
=C12*B12 (£500*11%=£55) and then have to use another cell to add B12+D12 (£500+£55=£555)
Is there a way to make the formula calculate and add the percentage at the same time in the same cell?
adding a % (2003 SP3)
-
steveh
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
adding a % (2003 SP3)
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
-
StuartR
- Administrator
- Posts: 12606
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: adding a % (2003 SP3)
If you have £500 in C12 and 11% in D12 then you can put the formula =C12*(1+D12) in the target cell to get a result of £555
StuartR
-
steveh
- SilverLounger
- Posts: 1952
- Joined: 26 Jan 2010, 12:46
- Location: Nr. Heathrow Airport
Re: adding a % (2003 SP3) - Closed
Thanks StuartStuartR wrote:If you have £500 in C12 and 11% in D12 then you can put the formula =C12*(1+D12) in the target cell to get a result of £555
That worked a treat
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin