Base a cell value on another cell's value

J

jh

I want to base a cell value on another cell's value. In
other words, if cell A2 <0, then in B2 I want to put the
word "attrition". If cell A2 >0, then I want to put the
word "hire".

Thanks in advance.
 
J

jh

Now I want to add an additional criteria.

If cell E2 <0 and C2 is null, then in G2 I want to put the
word "Attrition".
If cell E2 >0 and C2 is null, then in G2 I want to put the
word "Hire".
If cell E2 is not null and C2 is NOT null, then in B2 I
want to put the word "Offer".

Thanks in advance.
 
R

RagDyeR

Enter in G2:

=IF(AND(E2<0,C2=""),"attrition",IF(AND(E2>0,C2=""),"hire","C2 not null"))

What happens in G2 when C2 is *not* null?

Enter in B2:

=IF(AND(E2<>"",C2<>""),"offer","E2 and/or C2 are null")

What happens in B2 if E2 and/or C2 *are* null?
Do you want your first B2 formula from Don to come into effect?

=IF(AND(E2<>"",C2<>""),"offer",IF(A2>0,"hire","attrition"))

You've left out a lot of variables in your questions.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Now I want to add an additional criteria.

If cell E2 <0 and C2 is null, then in G2 I want to put the
word "Attrition".
If cell E2 >0 and C2 is null, then in G2 I want to put the
word "Hire".
If cell E2 is not null and C2 is NOT null, then in B2 I
want to put the word "Offer".

Thanks in advance.
 
J

jh

You're right. I didn't give this much thought. And after
thinking about it, I'm going to do it a different way.

Thanks for your help. I really appreciate it.
-----Original Message-----

Enter in G2:

=IF(AND(E2<0,C2=""),"attrition",IF(AND
Click to expand...
(E2>0,C2=""),"hire","C2 not null"))
 

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

How to determine the value within specific cell position? 5
Trying to run excel vba code when cell value changes from empty to entered value. 1
Cell Value from String Name 5
Cell locations 2
referring to formula in a non active cell from active cell 1
If then statement 2
Cond. formatting, based on other cell values? 3
Can you stop a formula from recalculating the second time 1

Top