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

Occasional Contributor



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)



Enter formula in cell O2 and copy down.

@cmckernan93 As a variant:




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