Sandy, could you help me with this one:

=IF($I$2="Active",VLOOKUP($E6,Data!$G$4:$AT$1587,2 8,0),"0")

I have this formula above in a cell. I want to add that if the vlookup
doesn't find anything and returns a #N/A than give me ZERO.

I'm doing this so I don't get #n/a in the column and my totals will add up
without giving me #n/a.

"Sandy Mann" wrote:

Assuming that you mean G6-N6 is negative try:

=IF(AND(G6=0,O6=0),P6,IF(G6=0,O6,MAX(0,G6-N6)))


--
HTH

Sandy

with @tiscali.co.uk


"BSantos" wrote in message
...
=IF(AND(G6=0,O6=0),P6,IF(G6=0,O6,G6-N6))

The above formula is in cell Q6 the results is a negative number. example
-2. I want to add to this formula above that if the results is less than
Zero
than give me Zero.

Any help!

B.