LinkBack URL
About LinkBacks
If I have two cells one with a number and the second cell with no value (blank). How can I create a formula that would look up both of these two cells and return the value of the first cell?
Many thanks
If I have two cells one with a number and the second cell with no value (blank). How can I create a formula that would look up both of these two cells and return the value of the first cell?
Many thanks
=if( AND(isnumber(A1),B1="") , A1, "")
assuming that A1 and B1 are
the cells in questionIf I have two cells one with a number and the second cell with no value (blank).
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank you for your reply.Originally Posted by etaf
But I don't think this is working. The cells are named so the formula is returning the name instead of the value in the cell. Also it's not returning the one with the value. Can you help?
What is the actual need of yours can you please clear it once??? if you want numeric numbers then simply put with ="cell reference".
It will be good if you can upload a sample workbook with desired result.
Go to advance and click on attachment link and attach the sample.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thats fine, its working for me now. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks