automatic selecting the highest cell

K

kimare

If got B2 which I would like to multiply the highest of the followin
cells B4-B5-B6, but only if B4:B6 are higher than 1,1 (not alltogete
but the one with the highest value).

Are someone able to help me with this formula? :rolleyes
 
M

Myrna Larson

Assuming , is you decimal separator (if not, I don't know what you mean), and
you require only that one of the numbers in B4:B6 be greater than 1.1,

=IF(MAX(B4:B6)>1.1,B2*MAX(B4:B6),B2)

If you mean that all 3 must be > 1.1

=IF(COUNTIF(B4:B6,">1.1")=3,MAX(B4:B6)*B2,B2)
 
Top