All Hokie, All the Time. Period. Presented by

The Lounge Board

BIT Hokie

Joined: 07/24/2017 Posts: 11
Likes: 1

What's this?

I'd Try Something using Min/Maxes


I'd try something using Min/Maxes. If all you care about is the range, then you just want to get the Min/Max of both 1) the four numbers you type in and 2) the Min/Max of the rows of four numbers. Then I'd do a nested if/then checking to see if the Min of your four numbers are >= the Min of the row and then check to see if the Max is

(In response to this post by Baltimore Hokie)

Posted: 03/07/2019 at 3:53PM


+0

Insert a Link

Enter the title of the link here:


Enter the full web address of the link here -- include the "http://" part:


75
Hide This

Current Thread:
 
  Excel question (advanced skill level) -- Baltimore Hokie 03/07/2019 3:43PM
  I would use Min and Max, that's the easiest way to do it -- MrBayAreaHokie 03/07/2019 7:37PM
  Probably not the most elegant formula, but ... -- Beerman 03/07/2019 5:21PM
  Advanced Excel users are masochists. -- banishedtothelounge 03/07/2019 5:10PM
  You can use an IF, AND and ABS -- jmanatVT 03/07/2019 5:09PM
  I'd Try Something using Min/Maxes -- BIT Hokie 03/07/2019 3:53PM
  Maybe a CHOOSE function? -- Tafkam Hokie 03/07/2019 4:02PM

Tech Sideline is Presented By:

Our Sponsors








vm307