| 0 |
Subject: Excel Formula
Posted by: beebop@work
- [38547161] Wed, Sep 08, 2004, 19:01
Hi, was hoping someone can help me with a spreadsheet they want here at work to work out stamp duty. I have no idea how to make it.
Up to $45000 is 3%. Over $45000 is %5. But, just say its $65000, thats 3% of 45000, and then 5% of 20000. Thats the part thats giving me most problems.
Any help would be appreciated.
Thanx. |
| 1 | Slackjawed Yokel
Leader
ID: 052347519
Wed, Sep 08, 2004, 19:10
|
=IF((cell_1<45000.),cell_1*.03,(45000.*.03+(cell_1-45000.)*.05))
that should serve as a starting point. I was too lazy to try it out.
|
| 2 | beebop@work
ID: 38547161
Wed, Sep 08, 2004, 19:18
|
Thanx, works perfectly.....
|
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|
|