Recent content by Susan J

Thanks Guys I think I would just like to add my photo. Can you give me some directive because I am not getting it. Susan

Hi Narayan Thanks for the ROUND formula (it works!) and for the formula modification. I, too, think that some of these forumulae are "wordy" and shall consider changing. Susan

Hi Hui My Calculation Options are set to Automatic but, this is my process. I prefer Cell O5 to be BOLD so, I format it this way and pull down on A21. After I do this, I can see that the sum formula updated correctly but, I also see that Cell O5 has reverted back to non-Bold. So, I "BOLD"...

Hi Secema Your English is just fine. Please upload your file. Thanks. Susan

Thanks Hui Yes, I do see what you are saying. I have deduced that this may be due to the way this file is protected also because both Locked and Hidden are activated. Does that make sense?

Hello I have been using this Help Site alot in the last week and want to thank those that have responded to my queries. I am a newbie with all these functions but, am learning thanks to your help. Hopefully, I soon will be able to give back instead of taking all the time. Thanks again, I...

Hello everyone I have built this spreadsheet using a table from Row 20 on. By selecting cell A21 and pulling on the lower right corner, I am able to add more rows with the formulas intact. I have also created a dynamic print range and the sums in Cells O5, E12 & E13 are dynamic also but...

Hi Everyone You will see from the enclosed that the formula for O21 is as follows: ((N21*J21)-(N21*J21)*L21))). You will also see the the Excel calculation total vs my calculator total is $499.44 vs $499.80 and $445.72 vs $445.49 for Cells O21 and O23. The manually calculated total must be...

Thanks Hui How did you get to know all of this information and it seems to be innate to you! I am majorly jealous. Have you looked at the file in my "Creating Custom Screen with Userform" question. It has formula's in it i.e. E9-19 but, you cannot see them. Why is that? It makes for a clean...

Hi Narayan I am hoping the following explanations will help: 1) I had to build this sheet to default first to Actual Cash Value Bulk Total and then to Replacement Cost Bulk Total and then drill down to the respective Per Item Totals. I also built this sheet for manual data entry to B20 to...

Thanks for the detailed response, in my case, I had to go into the VB editor and reset the UsedRange property. I appreciate your help.

Thanks very much for this, Hui. It works and I so appreciate your help.

OK, to clarify my insert line problem, I am trying to insert a line in Line 9. I am simply selecting the line, right clicking and selecting Insert. One line inserts but, then I get the above error message for the next insert. I hope that helps.

You are absolutely correct and I apologize. I failed to unhide Columns P & T that my question refers to. If you do so you will see what my question refers to. Someone mentioned that perhaps the value refered to in Column T could present in red font instead of a TRUE or FALSE statement. I...

Thank you so much Narayank991. I continue to learn and so appreciate your help. It makes total sense and you are correct, all of the DIV0!'s are now gone. I can insert one line, then I get the following error message: 'To prevent possible loss of data, Excel cannot shift nonblank cells off of...