Jet Fusion
Member
Hi
How would I alter an existing formula to show a blank cell if no data is in adjacent cells and copied down to multiple rows.
=IFERROR(IF(SEARCH("*Electronically*",D$11,1),"Electronic"),IF(SEARCH("*By Hand*",D$11,1),"Hand"))
Thanks in advance
Jet
How would I alter an existing formula to show a blank cell if no data is in adjacent cells and copied down to multiple rows.
=IFERROR(IF(SEARCH("*Electronically*",D$11,1),"Electronic"),IF(SEARCH("*By Hand*",D$11,1),"Hand"))
Thanks in advance
Jet