Microsoft Excel 2003 (full product)

say I have a number in k14.

I want to check this against cells k15 thru k23. If the number is > than I want to print text. How can I do this, it will only let me nest 7 if/ands?

Hi, If you want text if the value of K14 is greater than any of the individual values in cells K15 to K23 then this formula should do it:

=IF(K14>MAX(K15:K23),"Its bigger","It's not bigger")If you want to print text for each cell in the range K15 to K23 if the value is greater than the value in K14 then place this formula in Cell L15:

=IF(K15>$K$14,"It's bigger","It's not bigger")Then drag the formula down to cell L23.Regards

THANKS!

It works for K14 but when I go down to the next cell the formula excludes K14 in the comparison.

in other words if K18 is larger than k14 how do I set the range to K14:k23 while excepting K18?

got it. =IF(K16>MAX(K14:K25),"YOU ARE THE BIGGEST LOSER","")

Thanks for the MAX command!

=IF(K15>MAX(K14,K16:K23),"YOU ARE THE BIGGEST LOSER","")

Hi, Another function you might explore is RANK()

K L 42 6 49 2 43 5 32 10 38 7 35 9 37 8 50 1 44 4 47 3

Formula in L14:=RANK(K14,$K$14:$K$23)

Drag it down to L23:=RANK(K23,$K$14:$K$23)Note that the $ signs stop that part of the address from changing as you drag the formula to extend it.

Parts of the addresses without $ will change when dragged.Regards

Ask Your Question

Weekly Poll

Do you think third-party cookies should be blocked by browsers?

Discuss in The Lounge

Poll History