Forum Discussion

cmckernan93's avatar
cmckernan93
Copper Contributor
Oct 27, 2021
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 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

Resources