Hello,
I work on an Excel 2016 English version
I would like to have a number negative if there is an S in one column and a W in another column.
It is a program that has to present coordinates of a trip.
So if it contains South or West, then that number must be negative in order to continue using it in another file.
So as an example: So in column C there are different letters going from N or S, if there is an S in it, the value in column K should be a negative value.
Same for column F, if there is a W in column F, the value of the cell in column R should be a negative value.
How do you solve this please.
Thanks in advance for your expert help here on this wonderful forum.
Bookmarks