LinkBack URL
About LinkBacks
Solved...............................
Solved...............................
Last edited by craigy09; 06-21-2012 at 07:16 AM.
hi craigy09, your formula seems to be finding the amount after discount since you used 100%, 95%, 92% & 90% in the result_vector & multiply it by the course fees. if you wish to see the discount percentage, you should be using:
=LOOKUP( G2/7,{0,1,2,3},{0,0.05,0.08,0.1})
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
CourseFeesPaidTerm3.xlsx
done download it n check .
Cheers
SANDEEP
<< press the star * if u like
Oh whoops haha. Could you check this spreadsheet to make sure i did Course fee paid correctly aswell please?
Thanks for this
BUT you have used lookup function what ur quary says.. u need vlookup..for that you have to make a table showing in out ranges and dats it
Any chance you could help me out? Im completely useless with this vlookup
CourseFeesPaidTerm3.xlsx
done with vlookup
cheers .. if you find it helpful please click the star to the extreme left
Last edited by san2525; 06-21-2012 at 06:11 AM.
Thanks! Gave you a star
mark this thread SOLVED.. at the top of this thread... you can only do this
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks