Forum Discussion
Solved
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 posit...
=IF(OR(N2=5,N2=4),"Positive",IF(OR(N2=3,N2=2,N2=1),"Negative"))
Enter formula in cell O2 and copy down.
=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.
An alternative is to enter above formula in O2 and copy down.