I seek advice on a formula that I am trying to use in a spreadsheet.
There are 3 formulas in cells E1, E2 and E3 all work OK
I have put all the formulas into one, which is what I would like to have.
This is contained in cell B12. You will note that I have not placed the = symbol at this point as I get an error message.
I am not sure I the formula is to long or what is wrong.
Another pair of eyes may find where I have gone wrong.
Attached is the excel spreadsheet.
Click to view attachment