Dear Experts!
Another assistance is required!
I need cell A1 to show value in cell B1, but if cell B1 is blank i do not need it to display 0. It needs to leave it blank.
I used the below formula: =IFERROR(1/(1/MATCH(B1)),""), but it displays #NA error message.
Please assist!
Thanks!
Last edited by Abu Abdurakhim; 05-28-2013 at 03:18 AM.
=if(b1="","",b1) ???
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
SUPER!!! Thanks a lot! It works just great!
.........................
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks