• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Min and Max values not working

A

adamuce

Member
I am given daily ranges of gases prices

For example:
Monday 404-405
Tuesday 400-402

I then need to find the lowest and highest points for each day, which I do using the LEFT and RIGHT formula

Lowest point Monday: 404, Tuesday: 400
Highest point Monday: 405, Tuesday: 402

Then I need to find the lowest and highest point for the whole week so the lowest is 400 and the highest is 405. I try using the MAX and MIN formulae but it comes up with 0 as the result.

Can someone please help.

I have attached an example and what I need is in cells O4 and O5
 

Attachments

  • Min and MX value.xlsx
    10.5 KB · Views: 9
Left() and Right()are string functions and so return strings as outputs
In J4: Put =VALUE(LEFT(B4,3))
You get the idea now ?
 
To find the lowest and highest point for the whole week

1] "Lowest point" C8, enter array (CSE) formula :

=MIN(IMREAL(B4:F4&"i"))

2] "Highest point" C9, enter array (CSE) formula :

=MAX(-IMAGINARY(B4:F4&"i"))

72535
 
You must log in or register to reply here.
Back
Top