"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-