Forum Discussion
Solved
Compare 3 Numbers. Third number needs to be compared to previous two numbers and show result.
Need to compare numbers of column A (attached excel sheet) and want column B to reflect word: U, D or S based on following rules Rules: If A4 is more +ve than previous two numbers then U If A4 is...
Well, I had to Google what "+ve" and "-ve" meant---did you think that such abbreviations are part of common parlance?! They're not.--in order to come up with the attached. See if it works as you want.
And for all those who also don't know what those abbreviations mean:
- +ve means "positive"
- -ve means "negative"
Clear once you know, but obscure until you know.
Well, I had to Google what "+ve" and "-ve" meant---did you think that such abbreviations are part of common parlance?! They're not.--in order to come up with the attached. See if it works as you want.
And for all those who also don't know what those abbreviations mean:
- +ve means "positive"
- -ve means "negative"
Clear once you know, but obscure until you know.
