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

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
Ignore NA in a formula when I type it in a cell 4
how do I create a nonadjacent series for autofill to go by? 3
VLOOKUP 4
I want excel to input data in a cell from multiple cell choices 7
How do I avoid #NA result in a VLOOKUP 8
Formula to display last entry in a column populated with #N/As 4
subtraction in a list of numbers that resets with a label. 5

Back
Top