How do I create a formula that makes text in a cell = 0

G

Guest

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?
 
G

Guest

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

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

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I count # of cells with same value other column? 4
how do I create a nonadjacent series for autofill to go by? 3
VLOOKUP 4
How do I avoid #NA result in a VLOOKUP 8
Formula to display last entry in a column populated with #N/As 4
Geomean function 10
Excel formula, sum the value cell and if empty cell left blank 0
How do I hyperlink text in a cell to an embeded object 1

Top