LinkBack URL
About LinkBacks
Hi and welcome to the forum
This sounds fairly easy, using 3 nested IF()'s maybe, with your data in A1, something like...
=A1*0.8+IF(A1>10,(A1-10)*0.95,IF(A1>15,(A1-15)*0.95,0))
Hi and welcome to the forum
This sounds fairly easy, using 3 nested IF()'s maybe, with your data in A1, something like...
=A1*0.8+IF(A1>10,(A1-10)*0.95,IF(A1>15,(A1-15)*0.95,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks