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.


" wrote:

Cindy wrote:
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.

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 Cells
Number 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.