J Jagu Mar 9, 2009 #1 Actually I want to get value in one cell by typing in another cell F or M because there are different rate of male and female.
Actually I want to get value in one cell by typing in another cell F or M because there are different rate of male and female.
B Bob Phillips Mar 9, 2009 #2 =IF(A2="M",21,32) for example -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
=IF(A2="M",21,32) for example -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
