Thread: How do I create a formula that makes text in a cell = 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ebony1024
 
Posts: n/a
Default 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?
Reply With QuoteReply With Quote