Any spreadsheet Guru's out there? I need to take a value from a cell add 40% then I need to have the next cell display the result. That's the easy part. The hardest part is I need to delete the original cell so only the final value is shown;
eg. Cell a1 value =10
Cell b2 =SUM(I3*1.4) - ( this displays 14 )
I then need to delete the original cell a1 and replace it with the cell b2 result. This is because I have a price from a shop but want to mark it up by 40% and send out the spreadsheet to potential customers without seeing my buy price in cell a1.
There are approx 600 parts so I do not want to type in the result in each time from b2 into a1 each time and I cannot copy and paste the result from b2 as this copy the actual formula and not the figure. Hope this makes sense !!
Rep left for any help