Easy way to add a certain ammount for every 100 2

[BrenoAguiar]

I was wondering if there is a way to put on a excel spreadsheet a Function (or maybe a formula) for this problem:

For every $100 add $5.50. Example:

If I get $100 the result should be $5.50
If I get $157 the result should be $5.50
If I get $200 the result should be $11.00
If I get $201 the result should be $11.00
And so on...

Ant Help?

 

[AnotherHiggins]

Hi, BrenoAguiar

Try this:
[COLOR=blue white]=int(A1/100)*5.5[/color]
Change A1 to whatever cell you need.

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[EBGreen]

I don't have the time to write a formula right now, but I would do it like this:

Amount added = (Int(AmountGot/100))*5.5

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[BrenoAguiar]

Thanks Both. I can add that on a SUB too!. Thanks guys.

 

[AnotherHiggins]

Happy to help.


[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.