| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
