Forum Discussion
excel error mean calculation with #number! in column
I am designing a database. In this database I have a column with totals that is often updated. Part of the cells of this column are filled with numbers and part with #number! were not all info is avai...
Subodh_Tiwari_sktneer unfortunately it returns an error..
What error did you get?
Btw you may fix your Datedif formula to handle errors like this...
=IFERROR(DATEDIF(E2;F2;"d");0)
OR
=IFERROR(DATEDIF(E2;F2;"d");"")
You may choose one depending upon your requirement.