OPEN OFFICE: add cells then divide

[malk415]

All:

I am trying to make a formula to add the value in cell c20 through m20 and divide that sum by the value of another cell B20 and have the result in percent.

I wrote the formula like this: =SUM(C20:M20)/B20%
The formula seems to work and give the correct answer but the formula cell shows:

<tbody>
[TD="width: 86, bgcolor: #00FF66"]#DIV/0!
[/TD]

</tbody>

so something it not right in the formula.

Any help would be appreciated.

Mark

 

[malk415]

Re: add cells then divide

The only time that you will get a DIV/0 error is when B20 is zero or blank. You can include an IFERROR function to show the error as blank until you put data into B20.

=IFERROR(SUM(C20:M20)/B20,"")

I typed in exactly what you suggested.. and get "error 508"

Guess I can just put a phony value in B3 to get the blank sheet to work until I actually get information to type in.

Mark

 

[Joe4]

Re: add cells then divide

What does cell B3 have to do with anything? It is not being referenced in your formula, unless one of the cells in B20:M20 is a formula referencing B3.

If you are getting error 508, it might be because your version of Excel uses semi-colons instead of commas as argument separators, i.e. try:

[COLOR=#333333]=IFERROR(SUM(C20:M20)/B20;"")[/COLOR]

 

[malk415]

Re: add cells then divide

how can attach the spreadsheet so you can see what I am trying to do????

Mark

 

[Joe4]

Re: add cells then divide

Did you try any of the suggestions I recommended?

how can attach the spreadsheet so you can see what I am trying to do????

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.

Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

It would also be very helpful if you let us know which version of Excel you are using. And if it is a European or American version.

 

[malk415]

Re: add cells then divide

I tested all of the suggestions.... none worked.

It will take me a bit to figure out how to post a pic so please bear with me.......

I am not actually using excel I am using open office.

Mark

 

[63falcondude]

Re: add cells then divide

I am not actually using excel I am using open office.

Small detail that would have been worth noting from the beginning...

 

[malk415]

Re: add cells then divide

I am sorry but thought they were pretty much the same..... new to all this so just plugging along. trying to make a spread sheet for my shooting range to track users and any safety violations and end up with a percentage of unsafe acts on a daily basis when we have safety advisors at the range.

Mark

 

[Joe4]

Re: add cells then divide

I am not actually using excel I am using open office.

Well, that is a HUGE detail that explains a lot. They are NOT the same. They are made by entirely different companies.

With questions like this, you will want to be sure to mention that it is an Open Office question, and you will want to post it to the "General Excel Discussion and Other Questions" forum.
I will move this thread there now and change the title.