| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working on a big spreadsheet
I have been very proud of myself on this spreadsheet, but I'm stuck.
One one sheet, I have an attendance sheet, and on another sheet I have the identical page, used for a point amount. What I'm looking for, is if I put an A in a box, the corresponding box on the other sheet will be a 5, if a T, 2, if an L, 2, and if a TL, a 5. What formula would that be? Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet not working with filters. | Excel Worksheet Functions | |||
| Spreadsheet shortcuts not working | Setting up and Configuration of Excel | |||
| spreadsheet not working prob | Excel Discussion (Misc queries) | |||
| working spreadsheet from several workstations | Excel Discussion (Misc queries) | |||
| Functions not working in Spreadsheet | Excel Worksheet Functions | |||
Threaded Mode
