A2 = IF(A1="yes",5)
B2 = IF(B1="no",10)


babygoode Wrote:
Hi,
Is there any way to allocate a value to a cell depending what is in
another cell, so if A1=yes then A2=5 or B1=no then B2=10

Hope that makes sense

Thanks,


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=394367