Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF troubles
This is my IF function I'm trying to get to work.
=IF(L11=0,0,"=VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735 ,2,FALSE)") This works if L11 = 0 but if it does not = 0 it fails. If I use this VLOOKUP without outside of the IF function it also work. Is there something wrong with my syntax? Thanks for the help JG |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF troubles
=IF(L11=0,0,VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735,2 ,FALSE))
"JG" wrote: This is my IF function I'm trying to get to work. =IF(L11=0,0,"=VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735 ,2,FALSE)") This works if L11 = 0 but if it does not = 0 it fails. If I use this VLOOKUP without outside of the IF function it also work. Is there something wrong with my syntax? Thanks for the help JG |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF troubles
Get rid of the second equal sign and try it.
-- Bill Foley Microsoft PowerPoint MVP Microsoft Office Specialist Master Instructor www.pttinc.com "JG" wrote in message oups.com... This is my IF function I'm trying to get to work. =IF(L11=0,0,"=VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735 ,2,FALSE)") This works if L11 = 0 but if it does not = 0 it fails. If I use this VLOOKUP without outside of the IF function it also work. Is there something wrong with my syntax? Thanks for the help JG |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF troubles
Oops, AND quotes. The "False" item doesn't need quotes if it is a function.
-- Bill Foley Microsoft PowerPoint MVP Microsoft Office Specialist Master Instructor www.pttinc.com "Bill Foley" <pttincatitexasdotnet wrote in message ... Get rid of the second equal sign and try it. -- Bill Foley Microsoft PowerPoint MVP Microsoft Office Specialist Master Instructor www.pttinc.com "JG" wrote in message oups.com... This is my IF function I'm trying to get to work. =IF(L11=0,0,"=VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735 ,2,FALSE)") This works if L11 = 0 but if it does not = 0 it fails. If I use this VLOOKUP without outside of the IF function it also work. Is there something wrong with my syntax? Thanks for the help JG |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF troubles
I thought that myself and even tried it again after the suggestion.
When L11 is a zero it works and when it is a name (john) I get the formula in the cell. Teethless mama wrote: =IF(L11=0,0,VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735,2 ,FALSE)) "JG" wrote: This is my IF function I'm trying to get to work. =IF(L11=0,0,"=VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735 ,2,FALSE)") This works if L11 = 0 but if it does not = 0 it fails. If I use this VLOOKUP without outside of the IF function it also work. Is there something wrong with my syntax? Thanks for the help JG |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF troubles
This works =IF(L3=0,0,VLOOKUP(L3,Sheet1!$CA$1724:$CC$1735,2,F ALSE)) Thanks JG JG wrote: I thought that myself and even tried it again after the suggestion. When L11 is a zero it works and when it is a name (john) I get the formula in the cell. Teethless mama wrote: =IF(L11=0,0,VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735,2 ,FALSE)) "JG" wrote: This is my IF function I'm trying to get to work. =IF(L11=0,0,"=VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735 ,2,FALSE)") This works if L11 = 0 but if it does not = 0 it fails. If I use this VLOOKUP without outside of the IF function it also work. Is there something wrong with my syntax? Thanks for the help JG |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF troubles
JG wrote: This works =IF(L3=0,0,VLOOKUP(L3,Sheet1!$CA$1724:$CC$1735,2,F ALSE)) Thanks JG JG wrote: I thought that myself and even tried it again after the suggestion. When L11 is a zero it works and when it is a name (john) I get the formula in the cell. Teethless mama wrote: =IF(L11=0,0,VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735,2 ,FALSE)) "JG" wrote: This is my IF function I'm trying to get to work. =IF(L11=0,0,"=VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735 ,2,FALSE)") This works if L11 = 0 but if it does not = 0 it fails. If I use this VLOOKUP without outside of the IF function it also work. Is there something wrong with my syntax? Thanks for the help JG Maybe L11's format was Text, causing the formula to be shown rather than its result. Try reformatting L11 to General. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Troubles with asigning x values and values to a chart | Excel Discussion (Misc queries) | |||
AutoWordSelect in Combo Box Troubles | Excel Discussion (Misc queries) | |||
date sorting troubles | Setting up and Configuration of Excel | |||
List Box Troubles | Excel Discussion (Misc queries) | |||
Troubles with the OFFSET function | Excel Worksheet Functions |