formula for excel - Using IF to find maximum

Microsoft Excel 2003 (full product)
January 19, 2010 at 07:35:46
Specs: Windows XP
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?

See More: formula for excel - Using IF to find maximum

Report •

January 19, 2010 at 08:19:21

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.


Report •

January 19, 2010 at 10:46:49
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?

Report •

January 19, 2010 at 10:48:59
got it.


Thanks for the MAX command!

Report •

Related Solutions

January 19, 2010 at 10:50:49

Report •

January 19, 2010 at 11:10:07

Another function you might explore is RANK()

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

Formula in L14:

Drag it down to L23:

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.


Report •

Ask Question