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
|