Hi! I am trying to write an IF statement to help out my boyfriend. I need a
statement that says IF( F47 J47, output first name, if not output second
name,) And I know how to do that part, but here's the kicker.... if the two
cells are the same value, then it needs to go look at two other cells and
determine which of those is greater.

Any help is appreciated!!!

Something like:

=IF(F47=J47,MAX(X47,Z47),MAX(F47,J47))

change the X47 and Z47 to the other 2 cells you are comparing


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=495311

Melissa,
Something along these lines:

=IF(A1=B1,IF(A2B2,A2,B2),IF(A1B1,A1,B1))

If A1=B1 then test A2B2 otherwise test A1B1

HTH
"Melissa" wrote:

Hi! I am trying to write an IF statement to help out my boyfriend. I need a
statement that says IF( F47 J47, output first name, if not output second
name,) And I know how to do that part, but here's the kicker.... if the two
cells are the same value, then it needs to go look at two other cells and
determine which of those is greater.

Any help is appreciated!!!

"Melissa" wrote in message
...
Hi! I am trying to write an IF statement to help out my boyfriend. I
need a
statement that says IF( F47 J47, output first name, if not output second
name,) And I know how to do that part, but here's the kicker.... if the
two
cells are the same value, then it needs to go look at two other cells and
determine which of those is greater.

Any help is appreciated!!!

As a worsheet formula:

=IF(F47=J47, IF(F48J48, "First Name", "Second Name"), IF(F47J47, "First
Name", "Second Name"))


F48 and J48 need to be set whatever alternate cells you wish to compare. I
just picked those randomly.

-gk-

Thank you all very much for your help!!! ALl of those solutions worked. Now
I have just one other question....if when F47 =J47 is there a way I can
output a name if there isn't anything to compare in the other two cells???



"Melissa" wrote:

Hi! I am trying to write an IF statement to help out my boyfriend. I need a
statement that says IF( F47 J47, output first name, if not output second
name,) And I know how to do that part, but here's the kicker.... if the two
cells are the same value, then it needs to go look at two other cells and
determine which of those is greater.

Any help is appreciated!!!

Try:


=IF(A1=B1,IF(AND(A2="",B2=""),"Name here",IF(A2B2,A2,B2)),IF(A1B1,A1,B1))

"Melissa" wrote:

Thank you all very much for your help!!! ALl of those solutions worked. Now
I have just one other question....if when F47 =J47 is there a way I can
output a name if there isn't anything to compare in the other two cells???



"Melissa" wrote:

Hi! I am trying to write an IF statement to help out my boyfriend. I need a
statement that says IF( F47 J47, output first name, if not output second
name,) And I know how to do that part, but here's the kicker.... if the two
cells are the same value, then it needs to go look at two other cells and
determine which of those is greater.

Any help is appreciated!!!