| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula add if someone types PTO have it =0
I am trying to create what I would call an if/then formula in Excel 2003. If
someone types the letters PTO into a cell have tat equal zero in the formula. I have a sum formula of a set of cells I want Excel to be able to add a zero into the formula if someone types the letters PTO into the cell. My formula works great until someone types letters into a cell then - of course -I get a value error in the cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
| eliminating types of missing data from final formula | Excel Discussion (Misc queries) | |||
| Issue writing IF OR Error Formula Types | New Users to Excel | |||
| types of graphs in excel | Excel Discussion (Misc queries) | |||
| Summing types with one formula | Excel Discussion (Misc queries) | |||
Threaded Mode
