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