Hi everyone, I need some formula help.  The formula I am using in the sheet attached isn’t the right one.  In the sheet attached i have in row 3 automatically putting in U/A if in row 6 any ENGB or ENOP = 0.  So you can see in Column D and E i have 1 ENGB and 1 ENOP so U/A does not show up. But if i have 2 ENGB and 0 ENOP like in columns F and G i need those to show blank. but if ENOP = 2 or 1 and ENGB =0 i need it to show U/A.   I hope this makes sense.  I am probably overthinking this but cant figure it out.  any help is appreciated.  thank you.

​Hi everyone, I need some formula help.  The formula I am using in the sheet attached isn’t the right one.  In the sheet attached i have in row 3 automatically putting in U/A if in row 6 any ENGB or ENOP = 0.  So you can see in Column D and E i have 1 ENGB and 1 ENOP so U/A does not show up. But if i have 2 ENGB and 0 ENOP like in columns F and G i need those to show blank. but if ENOP = 2 or 1 and ENGB =0 i need it to show U/A.   I hope this makes sense.  I am probably overthinking this but cant figure it out.  any help is appreciated.  thank you.  Read More

​