 |
 | 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 / February 2008Formula to compare 2 cells
I need a formula to compare 2 cells. I want the result of the highest value cell to show up in the cell with the formula. Either cell can be the highest value cell at any given time. For example, cell BK27 has a value of 25 Cell BK43 has a value of 29 I want cell BK22 (which has the formula) to show the value of BK43 (29) in it. However, if cell BK27 were to change to 40, I would want the value of 40 to show in BK22. Does that make sense?  SignatureThanx, The MAX function will return the largest number in a range. So, in BK22, use the formula =MAX(BK30:BK40) Change the BK30:BK40 reference to the appropriate range reference. SignatureCordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2008 Pearson Software Consulting, LLC www.cpearson.com (email on web site) >I need a formula to compare 2 cells. I want the result of the highest value > cell to show up in the cell with the formula. Either cell can be the [quoted text clipped - 11 lines] > > Does that make sense? =MAX(BK27,BK22) you may want to add an If() to stop 0 showning for no values in the cells: =IF(COUNT(BK27,KB22),MAX(BK27,BK22),"") SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk >I need a formula to compare 2 cells. I want the result of the highest value > cell to show up in the cell with the formula. Either cell can be the [quoted text clipped - 11 lines] > > Does that make sense? Thank you so much, Sandy. Your If statement worked perfectly. You are awesome!!! SignatureThanx, > =MAX(BK27,BK22) > [quoted text clipped - 17 lines] > > > > Does that make sense? Glad that you found it usefull. Thanks for the feedback. SignatureRegards, Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Thank you so much, Sandy. Your If statement worked perfectly. You are > awesome!!! [quoted text clipped - 24 lines] >> > >> > Does that make sense? |
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.