I need help in excel to do the following:
cell D = cell C, unless C is blank in which case D should = cell B
Any tips?
Thanks
I need help in excel to do the following:
cell D = cell C, unless C is blank in which case D should = cell B
Any tips?
Thanks
Perhaps this?
=IF(C1="",B1,C1)
Change the row number to suit your data.
BSB
That worked perfectly. You saved me many hours of trial and error.
Thanks
No problem at all.. Happy to help
Don't forget to mark the thread as SOLVED if you're happy you have a working solution.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks