Thread: IF formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Betty K Betty K is offline
external usenet poster
 
Posts: 8
Default IF formula

I so much appreciate having this type of help available as I struggle to
learn more about formulas. Thank you to all.

Now, in Excel 2007, I have column U that returns a number, but in some cases
returns a "NA" (for "not applicable"). I need to add columns U+V+W+X, but
need to have the formula ignore the "NA" and just add V+W+X in those rows
where it appears.