Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ignore NA in a formula when I type it in a cell
=IF(F60,10,0)+IF(H6=1,10,0)+IF(I6=1,10,0)+IF(Q6 =0,10,0)+(K6*20)+(M6*20)+(O6*20)-SUM(R6+S6)
When I put a NA into cells K6, M6, O6, R6, S6, it won't calculate obviously because NA is not a number. It gives me the error message. Is there some way to bypass this when a cell has a NA? -- Thanks! Tyler |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want a formula to ignore text values in cell references | New Users to Excel | |||
Ignore leading zeros in a formula cell | Excel Discussion (Misc queries) | |||
How can I type 2 effictive formula in one cell? | Excel Worksheet Functions | |||
Ignore a cell used in a formula if it contains a negative value | Excel Discussion (Misc queries) | |||
set a cell up in a 'calculator' type formula< x+1+1+1+1=x+3 | Excel Worksheet Functions |