Hi All
I could use a bit of your help with the following please?
=IF(C61-D61=0,"Completed within agreed time!",C61-D61)
Problem is as you can see the formula takes the value from 2 cells, VALUE IN D61 is a close off date so it won't be inputted as the same time as the value in C61 which results in this Error #VALUE! haw can I modify it so that this error won't occour.
Thanks for your Help :-)
Dan
Wrap the formula in IFERROR....
=iferror(IF(C61-D61=0,"Completed within agreed time!",C61-D61),"")
or just....
=if(D61="","",IF(C61-D61=0,"Completed within agreed time!",C61-D61))
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks