Hello,
I would need some help with a formula I am trying to build.
Please refer to the file in the link as I think it would be much easier to understand what I am trying to achieve.
https://www.dropbox.com/s/tt1r2ut325qkzdq/Test.xlsx?dl=0
The formula in cell C1 should evaluate a string in cell A2 and return "Gross" or "Net" depending on the conditions set in the table in range F1 - J4.
However, if the combination of 1 or 2 digits appears at the beginning of the string, the formula should return N/A.
I managed to accomplish the first part (Gross, Net) but I am really struggling with the N/A part.
Any ideas?
Many thanks!!
I would need some help with a formula I am trying to build.
Please refer to the file in the link as I think it would be much easier to understand what I am trying to achieve.
https://www.dropbox.com/s/tt1r2ut325qkzdq/Test.xlsx?dl=0
The formula in cell C1 should evaluate a string in cell A2 and return "Gross" or "Net" depending on the conditions set in the table in range F1 - J4.
However, if the combination of 1 or 2 digits appears at the beginning of the string, the formula should return N/A.
I managed to accomplish the first part (Gross, Net) but I am really struggling with the N/A part.
Any ideas?
Many thanks!!