How do I set up a formula to calculate each, hundreds, or thousan.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I set up a formula in a cell to calculate material prices given by
either each, per hundred, or per thousand.
 
Hi
you need to provide more details about what you're trying to achieve.
e.g. give some examples, etc.
 
I am setting up purchase orders for electrical supply houses.
1/2" EMT is priced per hundred i.e. $33.00 per hundred feet.
Wiring is priced per thousand i.e. $27.00 per thousand feet.

Is there a way to set up the cell for calculating E=each, C=per hundred, or
M=per thousand or?

E would = 1
C would = .1
M would = .01
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert number to english text. example: 2=two, 100=hundred 2
How do I create the formula for this calculation? 1
Timecard functions and formulas 1
How convert Numeric number in words 2
Extracting information to automatically find previous value. 3
Set cell value if adjecent cell value is greater than 0 2
Antec Nineteen Hundred 2
CHANGE "C" TO 100 TO FIGURE EXTENDED COST 2

Back
Top