 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008How to max out results of a formula.
I have two formulas that work just fine. However, I need to max out at value based on the weight. Example. D3 = The person's score (10) E2= Their Goal (10) D15= That category's weight (in percentage) (35%) =IF(D3>0,(D3/E$2*(D$15)),"") Since the person reached the goal, they recieve (results of the formula is) 35%(d15). If they exceed goal, this formula currently goes higher than 35% (d15). I need to know how to cap it off/max it out at 35% (d15) 2nd Formula, same concept. Need for this to max out at the value in P15. =IF(P3="","",IF(P3>K$2,0,(P$15))) Thanx! Try this: =IF(D3>0,MIN(D3/E$2*D$15,D$15),"") Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) >I have two formulas that work just fine. > However, I need to max out at value based on the weight. [quoted text clipped - 20 lines] > > Thanx! Perfect-o!!! Thanx! When I become a millionaire.... I buying you a Krystal (or White Castle burger).... And that's With Chesse! You're very welcome...I'm glad I could help. ...and thanks for the generous offer! -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) > Perfect-o!!! > [quoted text clipped - 3 lines] > I buying you a Krystal (or White Castle burger).... > And that's With Chesse! > ...and thanks for the generous offer! Ron, I'm sulking. OP didn't offer me what he offered you in 2 of his earlier threads.  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- >>...and thanks for the generous offer! > > Ron, > I'm sulking. OP didn't offer me what he offered you > in 2 of his earlier threads. I've had White Castle, ONCE. I was thinking he didn't like the answer, was why the offer. I was just bantering with Ron, Bob. Think the OP was sincere in his thanks. SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.