I would like to know how to find an unknown value in a range.
I have 2 different IF formula's in 2 cells. If the one has an answer, the other one don't. Now I want to display the one with a answer in another cell.
Can anybody please help me with this problem?
A1 -if formula
A2 -if formula
A3 =if(A1="",A2,A1)
if not can you give a sample file with your sample output. thanks.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
May be something like this
For non answer cell resulting blank
Formula:
=TRIM(CONCATENATE(A1,B1))
Or
For non answer cell resulting 0
Formula:=MAX(A1,B1)
☚ Click ★ just below left if it helps, Boo?ath?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks