i need the vlookup because it returns a value if the cell matches
i have used the IF(F3<1) because in thisell its not actually empty but is a
formula
but is messy and wont compute
=IF(B3<1,â€â€,OR(ISNUMBER(SEARCH({"cmt","divs","fund"},A4)),J4="",(NOT(ISERROR(VLOOKUP(A3,'C:\Documents
and Settings\Gillian Mason\My Documents\MDA\[copy 2Share
Recommendations.xls]Stocks'!$B$10:$D$320,3,FALSE))),
VLOOKUP(A3,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy
2Share Recommendations.xls]Stocks'!$B$10:$D$320,3,FALSE),
IF(NOT(ISERROR(VLOOKUP(A3,'C:\Documents and Settings\Gillian Mason\My
Documents\MDA\[copy 2Share
Recommendations.xls]Hybrids'!$B$10:$D$320,3,FALSE))),
VLOOKUP(A3,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy
2Share Recommendations.xls]Hybrids'!$B$10:$D$320,3,FALSE),
IF(NOT(ISERROR(VLOOKUP(A3,'C:\Documents and Settings\Gillian Mason\My
Documents\MDA\[copy 2Share Recommendations.xls]Property &
Infrastructure'!$B$10:$D$320,3,FALSE))),
VLOOKUP(A3,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\[copy
2Share Recommendations.xls]Property & Infrastructure'!$B$10:$D$320,3,FALSE),0
)))),"")
basically if B3 is not 1 then and if there is not cmt or divs or fund then
do the formula, but i think i have it in the wrong order?
thank you so much
Peo Sjoblom said:
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 said:
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 said:
Try
=IF(AND(B3=1,F3=0),G3*C3,"")
--
Regards,
Peo Sjoblom
(No private emails please)
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
:
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(A13>0,1). i hope that wont matter
i am not sure of the way to write it correctly
thanks anyone
