Is there a simple way to handle named ranges when calculating the min/max values within (not of) those named ranges?

A1:A10 is called Range1 and has various calculated values
B1:B10 is called Range2 and has various calculated values
C1:C10 is called Result and each row should determine the Max (or min) of that row from Range1 and Range2

e.g. :
C1: =Max(Range1,Range2) Result should be the maximum value in row 1 between Range 1 and Range 2
C2: =Max(Range1,Range2) Result should be the maximum value in row 2 between Range 1 and Range 2
...

As written above, the result is just 0;

7/17/2015 2:23:04 PM

I'm not quite following what you're trying to do. Do you want output like this?:

A     B     C
10     1    10
5     50    50
12   12    12
...

7/17/2015 2:35:33 PM

yep

An if statement works fine for 2 named ranges; but I've 5+ ranges to compare, and I don't like those kinds of if statements.

[Edited on July 17, 2015 at 2:41 PM. Reason : .]

7/17/2015 2:37:09 PM

Ok, got it this time, I think. testing, so BRB

So this may turn out to be simple as shit, and I don't know why it works, but...

C1: MAX(VALUE(RANGE1),VALUE(RANGE2)) works for a row-by-row max/min comparison within named ranges.
(e.g., copy that formula down in C2..C10 to get the maximum value in each row from Rows 1..10 in ranges Range1 and Range2)

[Edited on July 17, 2015 at 2:57 PM. Reason : .]

7/17/2015 2:47:53 PM

C1=MAX(A1:B1)

7/17/2015 3:03:50 PM

[using named ranges] that's the entire reason I asked. I know how to do a cell reference formula for this; it's the named range thing that got me.

[Edited on July 17, 2015 at 3:15 PM. Reason : .]

7/17/2015 3:14:11 PM

I'm confused as to why you need the named ranges as opposed to cell references.

7/17/2015 3:22:06 PM