If Cell is blank, ignore formula and cell = blank

Hi guys,

My first post on here. Thanks in advance for the help!


Here are the formulas that I am currently using to extract data from a cell and paste it into another cell.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I would like to add a condition where IF R11 is blank, than the cell that this formula is in would also be blank.

Here is a sample of the data

TML ID Spool Location Spool2
001HT3EB-002 001 002 001
001HT3EB-003 001 003 001
002HT3EB-002 002 002 002
002HT3EB-003 002 003 002
003HT3EB-002 003 002 003


Again, thanks in advance for the help!

Formula:

Please Login or Register  to view this content.

Regards, TMS