|
addon to equation
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 |
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 |
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 |
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 |
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 |
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 |
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:\Docu ments 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" wrote: 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 |
| All times are GMT +1. The time now is 10:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com