minus value with specific condition through VBA code

[keshavtale]

please see in to attached file there is in A column some values if values of A column greater than 10 but less than 25 then minus 5 from that value
if values of A column greater than 25 but less than 100 then minus 10 from that value my expected result is in B column that is you can see
i do that manualy but how do that through VBA code

[Marc L]

Do you need to change column A or just have the result in column B ?

[alansidman]

Please Login or Register  to view this content.

[Marc L]

As for the result in column B it can be directly achieved without any loop just with 3 codelines …

[dangelor]

Possibly...

Please Login or Register  to view this content.

[keshavtale]

thanks now my problem is solved