IF AND or Whatever.

[Legacy 23340]

I am trying to do this.

=IF($G$7="U",E3/N11,IF($G$7="l",E3/N12))

I have no problem in setting up the formula, but my problem is that when the condition is met in each specific case( U or L), I want the "larger number to be divided by the smaller number" and no other way.

so eg. $E$3 = 435
$N$11 = 361
$N$12 = 1493

IF the condition is "U" then 435/361 = 1.2049(correct) but 361/435 = .8298 (incorrect)

IF the condition is "L" then 1493/435= 3.432 (correct) but 435/1493=.2913 (incorrect).

The values in all the cells change everytime I update the sheet and there is no knowing beforehand which value will be greater or lesser than the base value in $E$3.

And see guys (with your altruism) I am using absolute references now .

 

[just_jon]

Try

=IF($G$7="U",MAX(E3,N11)/MIN(E3,N11),IF($G$7="l",MAX(E3,N12)/MIN(E3,N12),""))

 

[Legacy 23340]

i should have thought of that before posting.

thanks anyways beers on the mansion!!!

Try

=IF($G$7="U",MAX(E3,N11)/MIN(E3,N11),IF($G$7="l",MAX(E3,N12)/MIN(E3,N12),""))