Formula Help
 

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

Formula Help
 

Try this:

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

then copy down as required.

Hope this helps.

Pete

On Aug 15, 1:19*pm, Compare Values
wrote:
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

Formula Help
 

Thank you so much

"Pete_UK" wrote:

Try this:

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

then copy down as required.

Hope this helps.

Pete

On Aug 15, 1:19 pm, Compare Values
wrote:
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