Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Brian

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

Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell reference question 4
Using Validation Ref # within LOOKUP 3
SUM with two conditions 4
How to use variable in reference 2
Want code to copy to ABOVE row 22 column A on sheet 1 10
If cell not null use that value 1
Understanding a formula 6
using data validation with several different lists 2

Back
Top