Constant Values

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

Guest

I am trying to assign constant values to the heading of a spreadsheet that I am creating so that when I put in the quantity of product that someone order is will automatically calculate the total cost for that one product, any suggestions?
 
Total cost = qty * price

A1 = qty 10
B1 = price 10.00
C1 = total cost formula =A1*B1

Biff
-----Original Message-----
I am trying to assign constant values to the heading of
Click to expand...
a spreadsheet that I am creating so that when I put in the
quantity of product that someone order is will
automatically calculate the total cost for that one
product, any suggestions?
 

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

Can I get a cell to automatically rezero after entering a value. H 1
multiply negative 2
requiring column entries 1
Determining Quantity and Keeping a Constant 4
Access Passing the value to a table 1
HELP! Find Data in columns next to known data then Calculate 2
adding decreasing numbers 3
f4 to make constant 5

Back
Top