% calculation
Hi
I have a row wiit prices that I need to calculate with different % every day, and want to have obe cell with absolute adress to put in the % number eks: in cell H4 4 its formatted as % and todays % is 20 In A4 I have this formula =A4-$H$4 but it do not subtrakt 20% I know I could use =A4*0,8 or =A4*$H$4 if the value of H4 is 0,8, then I get the right net price.. would have been nice to just put in the 20 instead of calculating the 0,8 first the % could be 27,483 :) Have a nice day -- Just a regular user |
% calculation
In H4, enter 20% (include the % sign)
Formula in B4, not A4 (that would cause a circular reference error): =A4*(1-$H$4) -- Kind regards, Niek Otten Microsoft MVP - Excel "Rockbear" wrote in message ... Hi I have a row wiit prices that I need to calculate with different % every day, and want to have obe cell with absolute adress to put in the % number eks: in cell H4 4 its formatted as % and todays % is 20 In A4 I have this formula =A4-$H$4 but it do not subtrakt 20% I know I could use =A4*0,8 or =A4*$H$4 if the value of H4 is 0,8, then I get the right net price.. would have been nice to just put in the 20 instead of calculating the 0,8 first the % could be 27,483 :) Have a nice day -- Just a regular user |
All times are GMT +1. The time now is 07:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com