It doesn't make any sense to use a vlookup formula to test for a match, use
either match or countif, however try to explain what you want with these
formulas and I am sure you will get a correct answer
if you want to test for zero in F3 just use

=IF(F3=0,"",Next_formula)



--
Regards,

Peo Sjoblom

(No private emails please)


"Micayla Bergen" wrote in message
...
to no avail. when i do that it gives me the first effect that i want,
which
is to be blank if F3 is 0, but then it changes another formula
=IF(ISERROR((VLOOKUP(A4,'share detail'!$A$2:$A$211,1,FALSE))),(H4+I4)) to
FALSE instead of the value, which would be the same as the product of
=IF(AND(B3=1,F3=0),G3*C3,"")

"Peo Sjoblom" wrote:

Try

=IF(AND(B3=1,F3=0),G3*C3,"")


--
Regards,

Peo Sjoblom

(No private emails please)


"Micayla Bergen" wrote in
message
...
Dave i have put it to a small equation instead to this effect
=IF(B3=1,IF(F3=0,G3*C3),"") but the result is FALSE instead of a blank.
how
can i make it blank?
thanks

"Dave Peterson" wrote:

Maybe...

=if(b13<1,"don't do formula-or whatever you
want",yourlongformulahere)



Micayla Bergen wrote:

i have this equation
=IF(NOT(ISERROR(VLOOKUP(A13,'C:\Documents and Settings\Gillian
Mason\My
Documents\MDA\[copy 2Share
Recommendations.xls]Stocks'!$B$10:$D$320,2,FALSE))),
which i want to make it so that if B13 = 1 then do the formula. B13
is
also
a formula =IF(A130,1). i hope that wont matter
i am not sure of the way to write it correctly
thanks anyone

--

Dave Peterson