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