Im using this formula to retrive number of hours worked, It is working ok however when the cell it is trying to retrieve data from is blank it is returning 0:00 i want it to leave the cell blank
=IFERROR(INDEX(Pivot!$B$3:$LA$26,MATCH($P$8,Pivot!$A$3:$A$25,0),MATCH(P12,Pivot!$B$2:$LA$2,0)),"")
ANy help would be great
Andy
Try:
Formula:
Please Login or Register to view this content.
wraps IF statement around your formula - IF(your formula returns 0,"",your formula)
Last edited by kev_; 09-06-2017 at 12:05 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Try this
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks Kev_ thats worked great
Last edited by Andyc6; 09-06-2017 at 12:53 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks