Sure You would put this in A2:

=IF(A1="Yes",5,"")

and this in B2:

=IF(B1="No",10,"")

Brian

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


--
babygoode
------------------------------------------------------------------------
babygoode's Profile: http://www.excelforum.com/member.php...o&userid=26109
View this thread: http://www.excelforum.com/showthread...hreadid=394367