Thread: ANDIF (i think)
View Single Post
  #2   Report Post  
chrisabberton
 
Posts: n/a
Default


I have actually solved this myself with some help from alan in chinks
post. thanks.

=IF(AND(H60,I60),I6,IF(AND(H60,J60),J6,IF(AND( H60,K60),K6,0)))

but now have a new problem.....

because A B C & D get their values from lookups, if the look-up cannot
find a value it is returning #N/A in some of these cells.

this is not a problem but it means that #N/A is shown in Z (above
example) for B, when it should be the value of C or D.

Can i force excel not to accept #N/A ?


--
chrisabberton
------------------------------------------------------------------------
chrisabberton's Profile: http://www.excelforum.com/member.php...o&userid=16872
View this thread: http://www.excelforum.com/showthread...hreadid=320531