Oct 27 2021 03:48 AM
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
Oct 27 2021 04:08 AM
Solution=IF(OR(N2=5,N2=4),"Positive",IF(OR(N2=3,N2=2,N2=1),"Negative"))
Enter formula in cell O2 and copy down.
Oct 27 2021 04:19 AM
Oct 27 2021 04:35 AM
Oct 27 2021 04:08 AM
Solution=IF(OR(N2=5,N2=4),"Positive",IF(OR(N2=3,N2=2,N2=1),"Negative"))
Enter formula in cell O2 and copy down.