i try to make a spreadsheet, which is attached, but when i try to input none value to c21 & d21 i get this div/o! error, how to elimate this error if i dont put any entry to said cels? thanks
i try to make a spreadsheet, which is attached, but when i try to input none value to c21 & d21 i get this div/o! error, how to elimate this error if i dont put any entry to said cels? thanks
Hi and welcome to the forum
Try this...
=IF(D21="","",(C21/D21)/24)
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
still having problems there is an error stating after D21=
e21=(c21/d21)/24 is what i like to happen
what if there is no input (empty data) for c21 & d21 to avoid div/0 error, to complement the table
thanks
still having problems there is an error stating after D21=
e21=(c21/d21)/24 is what i like to happen
what if there is no input (empty data) for c21 & d21 to avoid div/0 error, to complement the table
thanks
E21=(d21/c21)/24
d21 & c21 = no value in-putted
You better not post an Word.doc on an excel forum.
If you try to understand the formula in #2 of FDibbins, I bet your problem is solved.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
this should work for you...
in cell I21 =IFERROR(IF(H21="LS",((C21/D21)*(G21/24)),0),0)
in celll E21 =IFERROR((C21/D21)/24,0)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks