| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Worksheet Function?
Thanks in advance for reading this. I have a lookup function returning
whatever sheet (X) has from a specific cell. I would like it to return nothing if I am not useing that cell, right now it brings in a 0? =('Daily Input'!U42) This is the actual command that I am using.... |
|
#2
|
|||
|
|||
|
Try this....
=if(iserror(vlookup(yourlookupfunction))," ",(vlookup(yourlookupfuntion))) You can put some text, or nothing between the set of " ". Also, just check the number of brackets, as you can make a mistake quite easily on this. James "Krefty" wrote: Thanks in advance for reading this. I have a lookup function returning whatever sheet (X) has from a specific cell. I would like it to return nothing if I am not useing that cell, right now it brings in a 0? =('Daily Input'!U42) This is the actual command that I am using.... |
|
#3
|
|||
|
|||
|
Replace your formula with this
=IF(('Daily Input'!U42)=0,"",('Daily Input'!U42)) Vaya con Dios, Chuck, CABGx3 "Krefty" wrote in message ... Thanks in advance for reading this. I have a lookup function returning whatever sheet (X) has from a specific cell. I would like it to return nothing if I am not useing that cell, right now it brings in a 0? =('Daily Input'!U42) This is the actual command that I am using.... |
|
#4
|
|||
|
|||
|
What happens if U42 really holds a 0?
Maybe a slight change would be better: =IF('Daily Input'!U42="","",'Daily Input'!U42) (I got rid of some ()'s, too.) CLR wrote: Replace your formula with this =IF(('Daily Input'!U42)=0,"",('Daily Input'!U42)) Vaya con Dios, Chuck, CABGx3 "Krefty" wrote in message ... Thanks in advance for reading this. I have a lookup function returning whatever sheet (X) has from a specific cell. I would like it to return nothing if I am not useing that cell, right now it brings in a 0? =('Daily Input'!U42) This is the actual command that I am using.... -- Dave Peterson |
|
#5
|
|||
|
|||
|
Uh-huh, maybe..........I suppose it boils down to what is in the "unused"
cell, maybe the OP don't want "either" a "" or a 0 to return 0, then =IF(OR(('Daily Input'!U42)=0,('Daily Input'!U42)=""),"",('Daily Input'!U42)) (I gave the OP back their ()'s.....some folks just feel more comfortable with them)<g Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote in message ... What happens if U42 really holds a 0? Maybe a slight change would be better: =IF('Daily Input'!U42="","",'Daily Input'!U42) (I got rid of some ()'s, too.) CLR wrote: Replace your formula with this =IF(('Daily Input'!U42)=0,"",('Daily Input'!U42)) Vaya con Dios, Chuck, CABGx3 "Krefty" wrote in message ... Thanks in advance for reading this. I have a lookup function returning whatever sheet (X) has from a specific cell. I would like it to return nothing if I am not useing that cell, right now it brings in a 0? =('Daily Input'!U42) This is the actual command that I am using.... -- Dave Peterson |
|
#6
|
|||
|
|||
|
I don't think you need the "or" at all. Just checking for 0 will pick up the
"empty" 0 and the "real" 0. So it's back to your original or the minor modification version. CLR wrote: Uh-huh, maybe..........I suppose it boils down to what is in the "unused" cell, maybe the OP don't want "either" a "" or a 0 to return 0, then =IF(OR(('Daily Input'!U42)=0,('Daily Input'!U42)=""),"",('Daily Input'!U42)) (I gave the OP back their ()'s.....some folks just feel more comfortable with them)<g Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote in message ... What happens if U42 really holds a 0? Maybe a slight change would be better: =IF('Daily Input'!U42="","",'Daily Input'!U42) (I got rid of some ()'s, too.) CLR wrote: Replace your formula with this =IF(('Daily Input'!U42)=0,"",('Daily Input'!U42)) Vaya con Dios, Chuck, CABGx3 "Krefty" wrote in message ... Thanks in advance for reading this. I have a lookup function returning whatever sheet (X) has from a specific cell. I would like it to return nothing if I am not useing that cell, right now it brings in a 0? =('Daily Input'!U42) This is the actual command that I am using.... -- Dave Peterson -- Dave Peterson |
|
#7
|
|||
|
|||
|
Good point Dave................actually any of the three might serve the
OP's purpose......... Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote in message ... I don't think you need the "or" at all. Just checking for 0 will pick up the "empty" 0 and the "real" 0. So it's back to your original or the minor modification version. CLR wrote: Uh-huh, maybe..........I suppose it boils down to what is in the "unused" cell, maybe the OP don't want "either" a "" or a 0 to return 0, then =IF(OR(('Daily Input'!U42)=0,('Daily Input'!U42)=""),"",('Daily Input'!U42)) (I gave the OP back their ()'s.....some folks just feel more comfortable with them)<g Vaya con Dios, Chuck, CABGx3 "Dave Peterson" wrote in message ... What happens if U42 really holds a 0? Maybe a slight change would be better: =IF('Daily Input'!U42="","",'Daily Input'!U42) (I got rid of some ()'s, too.) CLR wrote: Replace your formula with this =IF(('Daily Input'!U42)=0,"",('Daily Input'!U42)) Vaya con Dios, Chuck, CABGx3 "Krefty" wrote in message ... Thanks in advance for reading this. I have a lookup function returning whatever sheet (X) has from a specific cell. I would like it to return nothing if I am not useing that cell, right now it brings in a 0? =('Daily Input'!U42) This is the actual command that I am using.... -- Dave Peterson -- Dave Peterson |
|
#8
|
|||
|
|||
|
Thank You
"CLR" wrote: Replace your formula with this =IF(('Daily Input'!U42)=0,"",('Daily Input'!U42)) Vaya con Dios, Chuck, CABGx3 "Krefty" wrote in message ... Thanks in advance for reading this. I have a lookup function returning whatever sheet (X) has from a specific cell. I would like it to return nothing if I am not useing that cell, right now it brings in a 0? =('Daily Input'!U42) This is the actual command that I am using.... |
|
#9
|
|||
|
|||
|
You're welcome Krefty, but read on.........Dave's adaptation might be more
to your liking, or even my second offering........ Vaya con Dios, Chuck, CABGx3 "Krefty" wrote in message ... Thank You "CLR" wrote: Replace your formula with this =IF(('Daily Input'!U42)=0,"",('Daily Input'!U42)) Vaya con Dios, Chuck, CABGx3 "Krefty" wrote in message ... Thanks in advance for reading this. I have a lookup function returning whatever sheet (X) has from a specific cell. I would like it to return nothing if I am not useing that cell, right now it brings in a 0? =('Daily Input'!U42) This is the actual command that I am using.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| SUMIF function referring to values on different Worksheet | Excel Worksheet Functions | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| The Help on the Excel Edate worksheet function contains an error:. | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Hybrid Mode
