Forum Discussion
Is the IF function the correct function to use?
Regarding the screenshot I have attached, I need to use a function or create a formula to perform the following task: The function needs to read the "Part Type" columns per row (ex. B2, D2, and F...
Hi dnomyar,
This is the formula you want:
=IF(OR(B2="MOTOR",D2="MOTOR",F2="MOTOR"),"MOTOR",IF(OR(B2="ELECTRICAL",D2="ELECTRICAL",F2="ELECTRICAL"),"ELECTRICAL",IF(OR(B2="MECHANICAL",D2="MECHANICAL",F2="MECHANICAL"),"MECHANICAL","N\A")))
HUGE thank you. Thanks for taking your time to help me. It is very much appreciated.