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