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?

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?