Dear Friends, I have created a formula for my database. It is giving partial result. I want to modify it for better output.
My condition is as follows: If cell j8= h1 then the formula should minus 0.5 from date difference in cell k8. If cell j8= h2 then the formula should minus 0.5 from date difference in cell k8. If cell j8= - then the formula should remain unchanged. My formula is as follows: =(IF(H8="-",0,IF(I8="-",0,IF(H8="",0,IF(I8="",0,IF(J8="h1",DATEDIF(H8,I8,"d")+1)-0.5))))) It’s very urgent to complete my database so please modify it for me today. Waiting for corrected formula. Thank you. Regards Mukesh Baviskar Mobile: 9403161157 Skype id: mukeshbaviskar Blog: http://mukeshbaviskar.blogspot.com Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in