| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a formula that makes text in a cell = 0
I working on a complex spreasheet where some of the entries are NA.
I need the spreadsheet to perform numerous calculations (add, subtract, multipy and divide). I want Excel to recognize that anytime it sees NA in a cell NA should equal 0 for calculation purposes. Instead I keep getting =VALUE? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a formula that makes text in a cell = 0
One way is to wrap your formulas in IF statements, like
=IF(ISNA(YourFormula),0,YourFormula) Vaya con Dios, Chuck, CABGx3 "Ebony1024" wrote: I working on a complex spreasheet where some of the entries are NA. I need the spreadsheet to perform numerous calculations (add, subtract, multipy and divide). I want Excel to recognize that anytime it sees NA in a cell NA should equal 0 for calculation purposes. Instead I keep getting =VALUE? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Allow combination of formula answer and text in one cell | Excel Worksheet Functions | |||
| CELL that picks up or inserts text with formula | Excel Discussion (Misc queries) | |||
| Can I create an IF formula for single cell w/ dif. text in Excel? | Excel Discussion (Misc queries) | |||
| Can I create and save a formula for text fields? | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
