Hopefully this is an easy one for people here, however i have been close to throwing my laptop around the room...
I am trying to enter a formula where the cell shows the results from either two other cells.
For example...
There will be values in either A1 or B1. There will never be values in both.
I want C1 to show either A1 or B1 depending on which has a value in it....
I thank you in advance for your help.
(the spreadsheet i am working on is much more complex than the example above, however I should be able to convert any answers to suit my needs)
Bookmarks