excel

  • Thread starter Thread starter Jagu
  • Start date Start date
J

Jagu

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting multiple conditions to return a figure from multiple cells 4
Chart from 1 Column 1
Summing data in columns 2
only return true values 6
Simple sort Problem 2
formula for adding and averaging 2
setting more than one condition and multiple ranges 1
Male/Female notation 1

Back
Top