I want to be able to show only value of a % calculation in a table, how can i do this?
For example if I have a £1000 and add 3% the formula =a2*1.03 will show the total of £1030, i just want it to show the working of the increase in the % but only show the £30.00 not the total as i want to be able to add it to a total later on in the table.
Anyone know how to add the formula or if it can be done?
Thanks
Bookmarks