Solved How to give values to cells with wording

April 11, 2012 at 18:30:35
Specs: Windows Vista
For an assignment I have to create a spreadsheet with columns that have given values. I am lost on how to assign a word a value without using to separate cells. Here is part of the assignment as an example:


Constants needs the following fields: Target Markup % ( give this the value of 102%), Target Price ( give this the value of $4.00 )
 
Base Costs needs the following fields: Qty on Hand (a numeric input field; the sum of the Warehouse On Hand), Cost Per Unit (a currency input field; the average of the warehouse Costs per Unit), Inventory Total Cost ( calculated as Qty On Hand times Cost Per Unit )


See More: How to give values to cells with wording

Report •


#1
April 11, 2012 at 19:35:54
✔ Best Answer
Why don't you want to use separate cells?

It reads to me that the "words" you are concerned with are nothing more than Column headings.

The only other thing I can think of is possibly Named Ranges. Look that up in the Excel Help files or DAGS.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
April 12, 2012 at 12:05:04
Thanks i realized i was overthinking it and that is what my professor wanted. Great help!

Report •

Related Solutions


Ask Question