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

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