Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Having a cell show X but read something else?
I have a small spread sheet set up to keep track of a grass cutting contract.
We have our area divided into sections A-G. Each section has a different dollar amount attached to it (section A $500, B $350, C $200, etc.) I list the sections across the top of my spread sheet. Down the side I list the date. If for instance we have the contractor cut sections A, B and C during the first date I put and X in cells B2, C2 and D2. I would like to then have this total $1050. How can I get the cells to read the dollar amount even though I'm typing an X in each cell? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to read the value of a cell | Excel Worksheet Functions | |||
CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL | Excel Discussion (Misc queries) | |||
Formatting to show/not show "DUE" and "RECEIVED" in cell | New Users to Excel | |||
Show cells have been read - linked | Excel Discussion (Misc queries) | |||
how read data downloaded on cd-rw, now show only code? | New Users to Excel |