Thread: nested if loop with logical OR/AND
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sa02000[_9_] sa02000[_9_] is offline
external usenet poster
  
Posts: 1
Default nested if loop with logical OR/AND

I am trying to write a formula to do the following.

1. I am trying to sum 7 cells in a row
2. before that I Check those 7 cells if they have "-" or #N/A or
number using if(OR....)). see my formula below.
2. If OR returns true for either "-" or #N/A check then if returns
(number zero) otherwise it returns the cell value itself and then I a
adding all those returned values.
3. But in some cell I get good results but in some cells I get #N/A.
tried few different versions but none of them worked.

Please Help.


=IF((OR(O6="#N/A",O6="-")),0,O6)+IF((OR(P6="#N/A",P6="-")),0,P6)+IF((OR(Q6="#N/A",Q6="-")),0,Q6)+IF((OR(R6="#N/A",R6="-")),0,R6)+IF((OR(S6="#N/A",S6="-")),0,S6)+IF((OR(T6="#N/A",T6="-")),0,T6)+IF((OR(U6="#N/A",U6="-")),0,U6)

I tried replacing o6="#N/A" with ISERROR(O6) in all of the formula bu
that did not work either.

Is there some other better way to do what I am trying to do??

Thanks,
Ja

--
sa0200
-----------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=47502

Reply With QuoteReply With Quote