| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Reference range of cells and perform subtraction or nothing depending on contents
Thanks in advance for the help. My sheet is for calculating per-diem for employees. Their starting per-diem is 600, and every day they work, I subtract 30 from the 600. So, on days that they work, I put a "W" in the corresponding day and an "O" if they don't work. Is there a formula that will examine a range of cells containing "W" or "O" and subtract 30 if "W" appears and do nothing if "O" appears, then keep a running total of the per-diem that is left?
Truly, Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a reference table and have different size cells | Excel Discussion (Misc queries) | |||
| Using a cells contents to reference a sheet. | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| How do I average a range of cells when one cell contains #N/A | Excel Discussion (Misc queries) | |||
Threaded Mode
