if function help

jim831 · #1 10-29-2010, 05:27 PM

Hi guys. I new to excel and need some help please. ok . In A1 to A50 and B1 to B50 i have blank cells. I will enter data to A1 an B1. I want to return a value into C1 based on the data in A1 and B1. so if A1 is greater than B1, Then C1 should = J. If B1 is greater than A1, Then C1 = G. Else C1 = blank. Thanks for ur help. jim

Kimberly · #2 10-29-2010, 05:56 PM

=IF(A1>B1,"J",IF(B1>A1,"G","")

C1 will appear to be empty only if A1=B1.

jim831 · #3 10-29-2010, 07:06 PM

Thank you that works sweet.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
is there an autocomplete function?	limlim	Word	1	05-09-2014 04:38 AM
Can't get AND function working	Scaffold	Excel	6	07-09-2010 01:41 AM
FIND function, where?	Yumin	Word	2	04-02-2010 07:16 PM
Need help on what function to use???	Primeraman	Excel	1	06-13-2006 10:16 AM
Help with Combination function	sanasath	Excel	0	12-13-2005 07:24 AM