software

Hello, I am trying to set up a sales spread sheet. What I would like to do
is divide the material by the bid amounts to get a percentage. Can anyone
help with this please? Right now I'm using a calculator. I've tried the
division formula but I think I'm doing something wrong.

Thanks.

How is the sheet set up? You have a column with material numbers and a
column with bid numbers? (Need a bit more of a description as to what you
are trying to divide or get a percentage from.)

quot;Cindyquot; wrote:

gt; Hello, I am trying to set up a sales spread sheet. What I would like to do
gt; is divide the material by the bid amounts to get a percentage. Can anyone
gt; help with this please? Right now I'm using a calculator. I've tried the
gt; division formula but I think I'm doing something wrong.
gt;
gt; Thanks.

Cindy wrote:
gt; I am trying to set up a sales spread sheet. What I would like to do
gt; is divide the material by the bid amounts to get a percentage. Can
gt; anyone help with this please? Right now I'm using a calculator. I've
gt; tried the division formula but I think I'm doing something wrong.

It would be good to show us what you are doing wrong. Perhaps
someone can explain your mistake.

If the cost of material is in A1 and the bid is in B1, the material as
a percentage of the bid is simply =A1/B1. You might also want to
format the cell so that the value appears as x% (Format gt; Cells gt;
Number gt; Percentage, and also select the number of desired decimal
places).

But there are other percentages that you might be interested in.
For example, if you are interested in the markup percentage, that
would be =(B1-A1)/A1 or =(B1-A1)/B1, depending on your definition.

HTH.

quot; wrote:

gt; Cindy wrote:
gt; gt; I am trying to set up a sales spread sheet. What I would like to do
gt; gt; is divide the material by the bid amounts to get a percentage. Can
gt; gt; anyone help with this please? Right now I'm using a calculator. I've
gt; gt; tried the division formula but I think I'm doing something wrong.
gt;
gt; It would be good to show us what you are doing wrong. Perhaps
gt; someone can explain your mistake.
gt;
gt; If the cost of material is in A1 and the bid is in B1, the material as
gt; a percentage of the bid is simply =A1/B1. You might also want to
gt; format the cell so that the value appears as x% (Format gt; Cells gt;
gt; Number gt; Percentage, and also select the number of desired decimal
gt; places).
gt;
gt; But there are other percentages that you might be interested in.
gt; For example, if you are interested in the markup percentage, that
gt; would be =(B1-A1)/A1 or =(B1-A1)/B1, depending on your definition.
gt;
gt; HTH.
gt;
Thank you very much for your suggestion. As I figured I was inputting the
wrong formula. I was using sum=, instead of just using what you wrote
=a1/b1.
I have several columns, job bid, then material used, labor paid and then
columns with each individual salesman.
I knew it was a lot simpler than using a calculator.
Again, thank you.
gt;

Hello again,

Well I got the #Value in the cell.
my bid amount is E1 and my material amount is in F1. So I wrote =F1/E1.

I also tried formatting the cells. That didn't work either.
Suggestions.quot; wrote:

gt; Cindy wrote:
gt; gt; I am trying to set up a sales spread sheet. What I would like to do
gt; gt; is divide the material by the bid amounts to get a percentage. Can
gt; gt; anyone help with this please? Right now I'm using a calculator. I've
gt; gt; tried the division formula but I think I'm doing something wrong.
gt;
gt; It would be good to show us what you are doing wrong. Perhaps
gt; someone can explain your mistake.
gt;
gt; If the cost of material is in A1 and the bid is in B1, the material as
gt; a percentage of the bid is simply =A1/B1. You might also want to
gt; format the cell so that the value appears as x% (Format gt; Cells gt;
gt; Number gt; Percentage, and also select the number of desired decimal
gt; places).
gt;
gt; But there are other percentages that you might be interested in.
gt; For example, if you are interested in the markup percentage, that
gt; would be =(B1-A1)/A1 or =(B1-A1)/B1, depending on your definition.
gt;
gt; HTH.
gt;
gt;

What are the 1st three numbers in column E and the 1st three in column F?

quot;Cindyquot; wrote:

gt; Hello again,
gt;
gt; Well I got the #Value in the cell.
gt; my bid amount is E1 and my material amount is in F1. So I wrote =F1/E1.
gt;
gt; I also tried formatting the cells. That didn't work either.
gt; Suggestions.
gt;
gt;
gt; quot; wrote:
gt;
gt; gt; Cindy wrote:
gt; gt; gt; I am trying to set up a sales spread sheet. What I would like to do
gt; gt; gt; is divide the material by the bid amounts to get a percentage. Can
gt; gt; gt; anyone help with this please? Right now I'm using a calculator. I've
gt; gt; gt; tried the division formula but I think I'm doing something wrong.
gt; gt;
gt; gt; It would be good to show us what you are doing wrong. Perhaps
gt; gt; someone can explain your mistake.
gt; gt;
gt; gt; If the cost of material is in A1 and the bid is in B1, the material as
gt; gt; a percentage of the bid is simply =A1/B1. You might also want to
gt; gt; format the cell so that the value appears as x% (Format gt; Cells gt;
gt; gt; Number gt; Percentage, and also select the number of desired decimal
gt; gt; places).
gt; gt;
gt; gt; But there are other percentages that you might be interested in.
gt; gt; For example, if you are interested in the markup percentage, that
gt; gt; would be =(B1-A1)/A1 or =(B1-A1)/B1, depending on your definition.
gt; gt;
gt; gt; HTH.
gt; gt;
gt; gt;

Column E: 105
Column F: 400

quot;tim mquot; wrote:

gt; What are the 1st three numbers in column E and the 1st three in column F?
gt;
gt; quot;Cindyquot; wrote:
gt;
gt; gt; Hello again,
gt; gt;
gt; gt; Well I got the #Value in the cell.
gt; gt; my bid amount is E1 and my material amount is in F1. So I wrote =F1/E1.
gt; gt;
gt; gt; I also tried formatting the cells. That didn't work either.
gt; gt; Suggestions.
gt; gt;
gt; gt;
gt; gt; quot; wrote:
gt; gt;
gt; gt; gt; Cindy wrote:
gt; gt; gt; gt; I am trying to set up a sales spread sheet. What I would like to do
gt; gt; gt; gt; is divide the material by the bid amounts to get a percentage. Can
gt; gt; gt; gt; anyone help with this please? Right now I'm using a calculator. I've
gt; gt; gt; gt; tried the division formula but I think I'm doing something wrong.
gt; gt; gt;
gt; gt; gt; It would be good to show us what you are doing wrong. Perhaps
gt; gt; gt; someone can explain your mistake.
gt; gt; gt;
gt; gt; gt; If the cost of material is in A1 and the bid is in B1, the material as
gt; gt; gt; a percentage of the bid is simply =A1/B1. You might also want to
gt; gt; gt; format the cell so that the value appears as x% (Format gt; Cells gt;
gt; gt; gt; Number gt; Percentage, and also select the number of desired decimal
gt; gt; gt; places).
gt; gt; gt;
gt; gt; gt; But there are other percentages that you might be interested in.
gt; gt; gt; For example, if you are interested in the markup percentage, that
gt; gt; gt; would be =(B1-A1)/A1 or =(B1-A1)/B1, depending on your definition.
gt; gt; gt;
gt; gt; gt; HTH.
gt; gt; gt;
gt; gt; gt;

Cindy wrote:
gt; Well I got the #Value in the cell. my bid amount is E1 and
gt; my material amount is in F1. So I wrote =F1/E1.

That is right, fundamentally. I think your problem lies elsewhere.

gt; I also tried formatting the cells. That didn't work either.
gt; Suggestions.

I suspect that either or both E1 and F1 had a Text format
before you entered their values, and you enter their values
in the form =2. At least, that is the only way I can get a
#VALUE error when E1 and F1 do not themselves have errors.

If that is the case, simply changing the cell format to Number
is not sufficient. In addition, you have to re-enter the values
in those cells. At least, that is what I find experimentally.

If that does not remedy your problem, you might consider
attaching your xls file to a posting, if your news reader permits
that. Normally, I deprecate that procedure. But in this case,
dealing with typing errors, it might be the best way to go.I wrote:
gt; I suspect that either or both E1 and F1 had a Text format
gt; before you entered their values, and you enter their values
gt; in the form =2. At least, that is the only way I can get a
gt; #VALUE error when E1 and F1 do not themselves have errors

I should mention that I am using Office Excel 2003. It is possible
that earlier revisions of Excel is less tolerate of other text forms
of numbers. So it might be easier for you to cause the #VALUE
due to cell format mismatch and/or typing errors.

Bottom line: explicitly change the cell formats for E1 and F1
to General or Number, re-enter the values in E1 and F1, say
quot;abracadabraquot; :-), and see if your problem goes away.alright, that makes sense, seeing as is, i exported the info from quickbooks
to excel and then moved some of the columns around. i will keep working at
it. thanks.

quot; wrote:

gt; Cindy wrote:
gt; gt; Well I got the #Value in the cell. my bid amount is E1 and
gt; gt; my material amount is in F1. So I wrote =F1/E1.
gt;
gt; That is right, fundamentally. I think your problem lies elsewhere.
gt;
gt; gt; I also tried formatting the cells. That didn't work either.
gt; gt; Suggestions.
gt;
gt; I suspect that either or both E1 and F1 had a Text format
gt; before you entered their values, and you enter their values
gt; in the form =2. At least, that is the only way I can get a
gt; #VALUE error when E1 and F1 do not themselves have errors.
gt;
gt; If that is the case, simply changing the cell format to Number
gt; is not sufficient. In addition, you have to re-enter the values
gt; in those cells. At least, that is what I find experimentally.
gt;
gt; If that does not remedy your problem, you might consider
gt; attaching your xls file to a posting, if your news reader permits
gt; that. Normally, I deprecate that procedure. But in this case,
gt; dealing with typing errors, it might be the best way to go.
gt;
gt;