Hi not sure if this is even possible...
I have cells E3-E13 which all have data validation lists, to label if a purchase order on a job has been invoiced or not. The options in these cells are "No", "Partly" or "Fully", the cell could also be blank if not selected/ required.
In cell I wanted a formula to return a text value based on the contents of cells E3-E13 to give an overall status of the job.
If all cells are blank, E3 must be blank
If the cells contain "No" or blanks, E3 must say "Not Invoiced"
If any cells say "Partly invoiced", E3 must say "Partly invoiced" even if some of the other cells in that range say "No" or "Fully"
E3 can only change to "Fully invoiced" once all cells have been updated to either "Fully" or are blanks.
Hope that makes sense, any ideas much appreciated.
Bookmarks