SOLVED

# setting value of one cell based on another cell's value

Occasional Contributor

# setting value of one cell based on another cell's value

Hello

quick query about an if query forumla

for the attached sample sheet

i want to set row O based on the value i input into row N.

So when i put into row N values 4 or 5, then positive will appear in row O

and vice versa for values 1,2 and 3 in row N but only to produce row

Thanks ,kind Regards

3 Replies
best response confirmed by cmckernan93 (Occasional Contributor)
Solution

# Re: setting value of one cell based on another cell's value

=IF(OR(N2=5,N2=4),"Positive",IF(OR(N2=3,N2=2,N2=1),"Negative"))

Enter formula in cell O2 and copy down.

# Re: setting value of one cell based on another cell's value

@cmckernan93 As a variant:

=IF(OR(N2={4,5}),"Positive","Negative")

# Re: setting value of one cell based on another cell's value

=VLOOKUP(N2,{1,"Negative";2,"Negative";3,"Negative";4,"Positive";5,"Positive"},2,0)

An alternative is to enter above formula in O2 and copy down.