Looking for an formula to do the following?

[vangher763]

Hello Members,

Kind of new to this formulating via Excel. I would some help in creating the following:

I am looking to create an equation for process: Searching for the word "Laser". If something other than Laser, "Laser Pass" remians "0" or "Darken out". If "Laser" is selected via "Process", "Laser Process Time" will multiply "Process Time" x "Laser Pass"

Attached is an excel file of what I had started but is having a hard time making it work.

Please help?

Thank you for your time!

Regards,

Vang Her

[#2]

Hi @vangher763 

You may use the below formula in column G. Please refer to the attached revised file.

=IF(IFERROR(SEARCH("Laser",B4,1),0)=1,(E4*F4),0)

Please let me know if it works for you.

Thanks

Tauqeer