Sum Function

**helge2** · 05-24-2012, 11:21 PM

I am using Excel 2008. In cell c7, I have an if statement that gives me a value of 2. In cell c15, I have another if statement that gives me a value of 3. I would now like excel to choose the biggest number from these two if statement values.

**dilipandey** · 05-25-2012, 12:09 AM

Hi Helge2,

Welcome to the forum.

You can use the below formula:-

=max(C7,C15)

Regards,
DILIPandey

<click on below 'star' if this helps>

**helge2** · 05-25-2012, 12:28 AM

OK, I tried =max(C7,C15) in cell c17 but it gives me a value of 0.

**dilipandey** · 05-25-2012, 12:35 AM

What values you have in C7 and C15?
Max function picks the maximum values in reference... I would suggest you to do little exploring on Max function .. upload the sample workbook in case of any issues. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Cutter** · 05-25-2012, 08:45 AM

Do you by chance have your IF()s, saying something like =IF(something,"2","") and =IF(something,"3","").
If so, then the MAX() will return 0 because you have made your 2 and 3 text values by enclosing them in quotes.
Remove the quotes from the numbers to make them numeric.

**helge2** · 05-25-2012, 12:37 PM

Nice! Getting rid of the quotation marks made it work! Thanks Guys!

**dilipandey** · 05-25-2012, 12:48 PM

Great...!!

Special thanks to Cutter

Helge2, suggest you to mark this thread as [SOLVED]. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Cutter** · 05-25-2012, 02:47 PM

@helge2
You're welcome, and thanks for the 'star tap'. Don't forget to mark your thread as SOLVED (for instructions see rule #9 by clicking Forum Rules @ top of page)

@dilipandey
Thanks for the 'star tap'. The crystal ball I got for my birthday is paying off.