Look in the help index for OR & AND

--
Don Guillett
SalesAid Software

"Trackeous" wrote in message
...
Would this also take care of multiple if statements, such as:

=IF(B3<"",B3, IF(B4<"",B4,"",Etc.))

Thought I found one solution, but something doesn't work correctly.

"CLR" wrote:

Try something like replacing your VLOKUP section with........

=IF(I19<0,YourVlookupFormula,0)

Vaya con dios,
Chuck, CABGx3


"KDD" wrote in message
...
How do i use this formula to return 0 without using ISERROR.

=INDEX($D$6:$K$10, VLOOKUP(I19,$B$6:$C$10,2), HLOOKUP(J19,$D$4:$K$5,2))

Problem is, if there is no value in I19, it returns #N/A, which in turn
effects all my other formulae linked to that cell into #N/A.

Pls help. Thank you.
--
KDDXB