Multiple nested if function help.xlsxHi,

Apologies that this was not clear, it is difficult to explain. I have added some additional examples in row 13 to 15 and added my comments in column M which explains the result.

Hope this is clearer.