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.

=IF(A2="M",21,32)

for example

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jagu" wrote in message
...
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.