IF STATEMENTS for text and different automatic outcomes/text.

Hi,

I am working on a sheet to direct instructions based on set criteria -

E.g.

Do the comments say:

Bee's if the Locations is...Regional or Metro or BY/BU/MJ then = Regional should be "Raise Work Order 45-Type $$$$ before adding comment". if the Location is...Metro then say "Raise Work Order 45-Click on Down Arrow on CREW-MET and lastly if the cells say BY/BU/ML then say "Raise Work Order 45-Type $$$$ before adding comment".

This is the formula I have so far:
=IF(OR(C4="Metro",C4="Regional",C4="BY/BU/MJ"),("Raise WorkSlip 45 - Type $$$$ before adding comment",and("Raise WorkSlip 45 - Click on Down Arrow on CREW: Choose MET ")),"Raise Workslip 45 - Type $$$$ before adding comment")

Obviously it is not working. It may not even be the best formula function to use but open to suggesttions. All I want is it to do this -
If this cell says this... then I want it to say this......
3 times over because there are only ever 3 locations with different actions to follow.

see attached - :Metering Services Projection Assistant v1.xlsm


Please help.....beginner advance user :-)


P.S I have attached my spreadsheet if it helps.

Hi,

Try:

Formula:

Please Login or Register  to view this content.

I hope this helps

Because there are 3 areas - Metro - Regional and BY/BU/MJ

there can, in some instances, be 3 different actions required.

Raise Work Order 45 - $$$$ (regional)
Raise Work Order 45 - MET (Metro)
Project Reading (BY/BU/MJ

any ideas?

Formula:

Please Login or Register  to view this content.

I hope this helps

Ajryan88 you are amazing but and it works perfectly but can I ask one more thing.........

What if nothing is type in the cell? What can I add on to make the cell blank when nothing is in C4?

I never get tired of hearing that ;P

Try this formula:

Formula:

Please Login or Register  to view this content.

If this solves your problem, please don't forget to mark this thread as solved (Thread Tools -> Mark As Solved) and please click on the * next to my post to say thanks