Hello. I am attempting to create a working document. I want to create an IF Then statement using a percentage. So if the % of penetration is above 20% then a different rate needs to be paid Cell F4 if above 40% the E5 needs to be used and the total revenue should calculate in column H. I'm not sure how to do this. Please let me know if anyone can assist on this
Last edited by CWallace212; 06-20-2014 at 03:08 PM.
Change column C to the minimum at each level, 0,20%,40%,60% etc
Then, =VOOKUP(whatevercell, $C$3:$F$10, 4)
Does that work for you?
Last edited by ChemistB; 06-20-2014 at 02:50 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks