Help

B

Brian

Hello,
How can I put these two formulas together

=IF(A22="","Not Assigned",A22)

and

=if (a22="comp","1comp",a22)
p.s. "comp" should somehow mean to say anything that starts with comp

Thank You
Brian
 
J

JulieD

Hi Brian

=IF(A22="","Not Assigned",IF(LEFT(A22,4)="comp","1comp",A22))

Cheers
JulieD
 
Top