Formula Help

[Compare Values]

HI, I have to set up a formula to multiply only if the number is greater $100
by 0.60, The first $100 are not charge but bigger than that is $0.60 per each
hundred starting at 101, 201, 301, etc..Please help

 

[Pete_UK]

Try this:

=INT((A1-1)/100)*0.60

then copy down as required.

Hope this helps.

Pete

 

[Compare Values]

Thank you so much

Try this:

=INT((A1-1)/100)*0.60

then copy down as required.

Hope this helps.

Pete