software

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?

One way is to wrap your formulas in IF statements, like

=IF(ISNA(YourFormula),0,YourFormula)

Vaya con Dios,
Chuck, CABGx3
quot;Ebony1024quot; wrote:

gt; I working on a complex spreasheet where some of the entries are NA.
gt;
gt; I need the spreadsheet to perform numerous calculations (add, subtract,
gt; multipy and divide).
gt;
gt; I want Excel to recognize that anytime it sees NA in a cell NA should equal
gt; 0 for calculation purposes. Instead I keep getting =VALUE?