I have a formula in w9 '=d9' which gives a correct result but if the cell d9 is blank then the w9 cell displays zero which i don't want. If the cell d9 is blank then the cell w9 should be blank and should not have zero display.
Solution please!
Mukesh
Your formula is not giving an error, it is returning what it show be.
try this instead...
=ifD9="","",D9)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi FDibbins,
Thank you. Now my problem is solved.
Thank you for solution.
Mukesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks