Ignore NA in a formula when I type it in a cell
Try this:
=((F60)+(H6=1)+(I6=1)+(Q6=0))*10+SUM(K6,M6,O6) *20-SUM(R6:S6)
"Tyler Manhattan" wrote:
=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
|