Karen Wrote:
I'm wanting to set a formula so that if cell A1 is "a" then C1 would be
3 and
if A1 is "b" then C1 would be 5.

Enter this formula in Cell C1:

=IF(A1=\"A\",3,IF(A1=\"B\",5,\"\"))

NOTE: for any other entry in Cell A1, Cell C1 will be blank.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=492188