IF and And Help?

[mkuter]

Hey again everyone and anyone.

I am trying to come up with a little automation for my sheet and this is essentially what I am trying to do.

I have a drop down to select a certain status (More Info Needed, Scheduled, Testing, Completed). Essentially what I want to do is I want to be able to select a status and have it automatically put a value in for an overall status percentage. So More Info Needed would be 25%, Scheduled would be 50%, Testing would be 75% and Completed would be 100%.

I managed to do this and get it for the 100% =IF([@[Dev Status]]="Completed",1,0) . I also tried adding some and statements in there and that is where the wheels came off.

Any help would be appreciated.

 

[Special-K99]

Can I just add

It wont pick up the second "Completed"
Should probably be

=LOOKUP(F2,{"Completed","More Info Needed","Scheduled","Select","Testing"},{1,0.25,0.5,0.75,0})

 

[mkuter]

Amazing!!! Thank you so much. I swear I learn so much from this forum! You all are some terrific human beings.

 

[gaz_chops]

Can I just add

It wont pick up the second "Completed"
Should probably be

=LOOKUP(F2,{"Completed","More Info Needed","Scheduled","Select","Testing"},{1,0.25,0.5,0.75,0})

I think your zero is in wrong place, I edited mine.

=LOOKUP(F2,{"Completed","More Info Needed","Scheduled","Select","Testing"},{1,0.25,0.5,0,0.75})

 

[gaz_chops]

You're welcome, the team work got us there.

(Although my original formula should have worked )