I have three columns of numbers
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A1
[/TD]
[TD]B1
[/TD]
[TD]C1
[/TD]
[/TR]
[TR]
[TD]1158.50
[/TD]
[TD]1562.50
[/TD]
[TD]1250.00
[/TD]
[/TR]
</tbody>[/TABLE]
I need a formula that looks at all three numbers and returns one of them based on criteria.
If A1 is bigger than B1 or C1, then B1 should be returned. If C1 is bigger than A1, then C1 should be returned. If A1 is bigger than C1 but smaller than B1 then A1 should be returned.
Nothing I am familiar with IF(AND, IF(OR, SUMIFS will work.
Any ideas?
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A1
[/TD]
[TD]B1
[/TD]
[TD]C1
[/TD]
[/TR]
[TR]
[TD]1158.50
[/TD]
[TD]1562.50
[/TD]
[TD]1250.00
[/TD]
[/TR]
</tbody>[/TABLE]
I need a formula that looks at all three numbers and returns one of them based on criteria.
If A1 is bigger than B1 or C1, then B1 should be returned. If C1 is bigger than A1, then C1 should be returned. If A1 is bigger than C1 but smaller than B1 then A1 should be returned.
Nothing I am familiar with IF(AND, IF(OR, SUMIFS will work.
Any ideas?