| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Help
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 |
|
#2
|
|||
|
|||
|
Hi Brian
=IF(A22="","Not Assigned",IF(LEFT(A22,4)="comp","1comp",A22)) Cheers JulieD "Brian" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
Julie,
Thank you very much. Brian "JulieD" wrote: Hi Brian =IF(A22="","Not Assigned",IF(LEFT(A22,4)="comp","1comp",A22)) Cheers JulieD "Brian" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
you're welcome
"Brian" wrote in message ... Julie, Thank you very much. Brian "JulieD" wrote: Hi Brian =IF(A22="","Not Assigned",IF(LEFT(A22,4)="comp","1comp",A22)) Cheers JulieD "Brian" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
