rochytall2000
New Member
 Joined
 Sep 15, 2006
 Messages
 24
 Office Version

 365
 2019
I need help with the below formula
=H3(H3*$F$3)
I'm trying to return the revised figure once a percentage has been taken off but my formula is not working correctly (as expected I should say)
H3 is the initial value
F3 contains the percentage value (0.01)
but for some reason it is taking too much off when I copy to the next cell and so on
For example
9707(97) = 9610
9610(96) = 9514 but Excel is returning 9418 subtracting 192
In effect doubling the value of the percentage to be subtracted
If I do it where i Just have the percentage amount returned it works but I want to return the new value of H3 in I3 not the percentage value.
Help please
Thanks
Duncan
=H3(H3*$F$3)
I'm trying to return the revised figure once a percentage has been taken off but my formula is not working correctly (as expected I should say)
H3 is the initial value
F3 contains the percentage value (0.01)
but for some reason it is taking too much off when I copy to the next cell and so on
For example
9707(97) = 9610
9610(96) = 9514 but Excel is returning 9418 subtracting 192
In effect doubling the value of the percentage to be subtracted
If I do it where i Just have the percentage amount returned it works but I want to return the new value of H3 in I3 not the percentage value.
Help please
Thanks
Duncan