This is my first post so please bare with me.
I am trying to create a report that will put an X in a box "IF/OR" a criteria is met on another sheet.
I am currently using (example) A1=(IF(OR('SHEET1'!A1>=0,'SHEET1'!B1>=0,'SHEET1'C1>0),"X",""))
My problem is that when I drag this to the right, I am not able to get the next formula in cell "B1" to correspond to D1,E1,F1.
I have tried writting the formula out for 3 cells, then highlighting all 3 and dragging right, hoping that Excel would see the pattern, but this does not work.
I would like to see the following when I drag right:
A1=(IF(OR('SHEET1'!A1>=0,'SHEET1'!B1>=0,'SHEET1'C1>0),"X",""))
B1=(IF(OR('SHEET1'!D1>=0,'SHEET1'!E1>=0,'SHEET1'F1>0),"X",""))
Instead, I am seeing
A1=(IF(OR('SHEET1'!A1>=0,'SHEET1'!B1>=0,'SHEET1'C1>0),"X",""))
B1=(IF(OR('SHEET1'!B1>=0,'SHEET1'!C1>=0,'SHEET1'D1>0),"X",""))
How do I, or is it even possible, to get my formula to jump 3 cells instead of only one. I need to drag this about 400 cells right. The drag down works perfectly fine, but I can not get the drag right to workout. 400 formulas will take a lot of busy work.
P.S. I am not a computer programmer by any means, so please explain a bit for the average person to understand.
Thank you all for the help/advice.
Bookmarks