Get instant live expert help with Excel or Google Sheets

Hello, I'm using Excel as my register system. I can not get the total bar to calculate over $100 dollars. the formula is in B20 it is =SUM(B2:B19) if the amount i enter exceeds 99 it cell B20 displays #### instead of a total. Same thing with cell B22 which is where it should display change. WHAT DO I DO Please Help!

Hi I need help for a formula to convert text into columns in excel. 100150!Abacavir Ziagen 20mg/mL 240mL Mixture 240mL!553036!CP use 100151!Abacavir - Lamivudine Kivexa 600mg-300mg Tablet 30!553036!CP use 100152!Abacavir - Lamivudine - Zidovudine Trizivir 300-150-300mg Tablet 60!553036!CP use 100155!Abacavir Ziagen 300mg Tablet 60!553036!CP use 100200!Abciximab Reopro 10mg/5mL Inj 1!550131!CP use 100201!Filter - Sterile Durapore PVDF 0.22 micron For Use with Reopro 33mm Unit 50!556031!CP use 100210!Abatacept Orencia 250mg Inj 1!554006!CP use 100230!Acamprosate Campral 333mg Tablet 180!554231!CP use 100250!Acarbose Glucobay 50mg Tablet 90!550076!CP use 100255!Acarbose Glucobay 100mg Tablet 90!550076!CP use 100831!Acetazolamide Glaumox 500mg Inj 1!555111!CP use 101047!Acetazolamide Diamox 250mg Tablet 100!555111!CP use 101400!Acetone Merck 100mL Solution 1!556031!CP use 101408!Acetone Merck 2.5L Solution 1!556031!CP use 101792!Acetylcholine Miochol E 20mg/2mL Solution 1!555111!CP use 101987!Acetylcysteine OmegaPharm 800mg/4mL (20%) Inhalation 10!555031!CP use 101988!Acetylcysteine DBL 2g/10mL Inj 10!556031!CP use 102100!Acitretin Neotigason 10mg Capsule 100!551051!CP use 102115!Acitretin Neotigason 25mg Capsule 100!551051!CP use 102500!Adalimumab Humira 40mg/0.8mL Prefilled Syr 2!554006!CP use 102503!Adalimumab Humira 40mg/0.8mL Prefilled Syr 6!554006!CP use 102507!Adalimumab cartridge Humira 40mg/0.8mL Pen 6!554006!CP use 102508!Adalimumab Humira 20mg/0.4mL Prefilled Syr 2!554006!CP use 102509!Adalimumab cartridge Humira 40mg/0.8mL Pen 4!554006!CP use 102510!Adalimumab cartridge Humira 40mg/0.8mL Pen 2!554006!CP use

Hi, I have an excel file with 6 columns. Columns B-F are the columns I need help with. I need HTML inserted in each cell. Then I need all of the cells in each row to be combined in a new cell with each bullet point on a separate line within the cell. Please Advise Thanks

Hello, I have weekly data (more than 1000 data points each week) collected that I would like to plot them using excel. I want to know how to add each week data into the same worksheet without having to re-plot the data again and again. I also would like to have the axis label by monthly (for example: Day 1, Day 30, Day 60, etc.) Thank you so much for your help. I'm truly appreciate it. Sincerely, Wish I know Excel more.

Dear Expert01, I couldn't upload the excel binary workbook (.xlsb) here since this did not let me. I was hoping if you can help me figure out how to add more data without losing the format of the previous data already on the worksheet. When i upload data, I made sure that the date column is formatted to MDY but it somehow did not applied when the new data added into the current worksheet. Thank you!

I need help trying to get excel to show the difference between two numbers for an entire spreadsheet. Please Help!!!

Hi I need help with an excel spreadsheet to create a formula to do a certain function

Good Afternoon, We have set up an excel spreadsheet and are running a Visual Basic formula on our Windows computer but this will not copy over to our Mac.. The formula is shown below.. can you please help with how we can run this formula and make it compatible between both the Mac and Windows computers Thank you

Hi, I need to translate an excel sheet from spanish to english, as I don't speak the language. Please help

The data in the Excel spread sheet attached needs to be collected into a table and generate a set of charts and graphs in order to expose a possible trend. Then Calculate the mean, standard deviation and Z-scores for each set of seven-day data points. i Need help