Good day everyone,
I have been scouring the web for over an hour and can't find a solution to this.
I am trying to come up with something that will either perform a calculation or concatenate the contents of a cell with a word. The deciding factor in this would be a word in A1 for example that if it begins with an asterix, the result would be A2 concatenated with " - PASS", if the word does not begin with an asterix, then a calculation would be performed instead such as A3 + A4.
Thank you in advance for any assistance offered.
I have been scouring the web for over an hour and can't find a solution to this.
I am trying to come up with something that will either perform a calculation or concatenate the contents of a cell with a word. The deciding factor in this would be a word in A1 for example that if it begins with an asterix, the result would be A2 concatenated with " - PASS", if the word does not begin with an asterix, then a calculation would be performed instead such as A3 + A4.
Thank you in advance for any assistance offered.