Evaluate 4 criteria in a spreadsheet

[Gorbs]

I have a situation where I would like to evaluate 4 criteria in a spreadsheet
Cell F4 = Cell in which formula is.
Cell D4 = qty required
Cell E4 = qty produced
Cell O4=status (In this cell there are 2 digit codes, which indicate “completed” by adding an “X” in front of the code eg. BC indicates bunching required and XBC indicates bunching done.
1. What I require is for Cell F4 to contain a formula which compares Cell D4 to Cell E4 and if C4>=D4 and Cell O4 contains any code with an X in front of it, then the result should be “Complete”
2. If C4>=D4 and Cell O4 does not contain any code with an X in front of it, then the result should be “Incomplete”
3. C4<=D4 and Cell O4 contains any code with an X in front of it, then the result should be “Issued”
4. If C4<=D4 and Cell O4 does not contain any code with an X in front of it, then the result should be “Incomplete”
Any assistance would be greatly appreciated

[Pete_UK]

Try this in F4:

=IF(LEFT(O4)<>"X","Incomplete",IF(C4>=D4,"Complete","Issued"))

Hope this helps.

Pete

[Gorbs]

Thank You Pete,
I can see why I battle - I made a careless error in my post, namely I referred to Cell C4 instead of E4.
Your solution is spot on and once I replaced C4 with E4 everything runs like a Rolex.
Thanks for the solution and the prompt response
Andre Van Der Walt

[Pete_UK]

Glad to help.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you, and leave a private comment if you like, by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete