| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Syntax For Conditional Formula
HI,
I want to say if L3780 = "applications", then replace it with "Global Trade SV" Since there is a formula in the field, I need to place this as a condition...can anyone help me?? Thanx |
|
#2
|
|||
|
|||
|
Hi
not sure what you're after here, but a formula can not update another cell -only the cell that the formula is in. what is the formula in L3780 ... maybe we can alter this to show Global Trade SV instead of applications Regards JulieD "Dmorri254" wrote in message ... HI, I want to say if L3780 = "applications", then replace it with "Global Trade SV" Since there is a formula in the field, I need to place this as a condition...can anyone help me?? Thanx |
|
#3
|
|||
|
|||
|
hi,
You may write the formula on the next cell as =if(L3780="applications","Global Trade SV",L3780),if you want L3780 there.Otherwise,if you want blank cell,if the condition is not satisfied ,then =(if(l3780="applications","Global trade SV","") "Dmorri254" wrote: HI, I want to say if L3780 = "applications", then replace it with "Global Trade SV" Since there is a formula in the field, I need to place this as a condition...can anyone help me?? Thanx |
|
#4
|
|||
|
|||
|
Hi,
Let me explain further....L3780 contains this formula: =IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID( VLOOKUP(H3780,Tivoli,4,FALSE),1,15)) What it is doing is looking at another table and bringing me back some text I get form a query...now we are using a different system but I need to merge information form one system into this one...so in order to remain consistant with MY data, I need the word now used for Global Trade SV (applications) to remain Global Trade SV....so this means in relation to the formula in L3780 is this....TIVOLI,4 brings back Global Trade SV....so instead of modifying the formula, I can use a condition that says if applications is returned, replace it with Global Trade SV... Does this help? If the existing formula can be modified then that would be even better... Thanx "JulieD" wrote: Hi not sure what you're after here, but a formula can not update another cell -only the cell that the formula is in. what is the formula in L3780 ... maybe we can alter this to show Global Trade SV instead of applications Regards JulieD "Dmorri254" wrote in message ... HI, I want to say if L3780 = "applications", then replace it with "Global Trade SV" Since there is a formula in the field, I need to place this as a condition...can anyone help me?? Thanx |
|
#5
|
|||
|
|||
|
Hi
try =IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","Global Trade SV",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))) - i'm thinking that this could be neatened up a bit but as it's 12.45am my brains too asleep to see it :) - let me know how you got with this ... Cheers JulieD PS i prefer to use ISNA instead of ISERROR .. it isn't as all encompassing and doesn't hide "unexpected" errors. "Dmorri254" wrote in message ... Hi, Let me explain further....L3780 contains this formula: =IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID( VLOOKUP(H3780,Tivoli,4,FALSE),1,15)) What it is doing is looking at another table and bringing me back some text I get form a query...now we are using a different system but I need to merge information form one system into this one...so in order to remain consistant with MY data, I need the word now used for Global Trade SV (applications) to remain Global Trade SV....so this means in relation to the formula in L3780 is this....TIVOLI,4 brings back Global Trade SV....so instead of modifying the formula, I can use a condition that says if applications is returned, replace it with Global Trade SV... Does this help? If the existing formula can be modified then that would be even better... Thanx "JulieD" wrote: Hi not sure what you're after here, but a formula can not update another cell -only the cell that the formula is in. what is the formula in L3780 ... maybe we can alter this to show Global Trade SV instead of applications Regards JulieD "Dmorri254" wrote in message ... HI, I want to say if L3780 = "applications", then replace it with "Global Trade SV" Since there is a formula in the field, I need to place this as a condition...can anyone help me?? Thanx |
|
#6
|
|||
|
|||
|
Thanx I will try it .....and let you know..get some sleep..
CIAO "JulieD" wrote: Hi try =IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","Global Trade SV",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))) - i'm thinking that this could be neatened up a bit but as it's 12.45am my brains too asleep to see it :) - let me know how you got with this ... Cheers JulieD PS i prefer to use ISNA instead of ISERROR .. it isn't as all encompassing and doesn't hide "unexpected" errors. "Dmorri254" wrote in message ... Hi, Let me explain further....L3780 contains this formula: =IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID( VLOOKUP(H3780,Tivoli,4,FALSE),1,15)) What it is doing is looking at another table and bringing me back some text I get form a query...now we are using a different system but I need to merge information form one system into this one...so in order to remain consistant with MY data, I need the word now used for Global Trade SV (applications) to remain Global Trade SV....so this means in relation to the formula in L3780 is this....TIVOLI,4 brings back Global Trade SV....so instead of modifying the formula, I can use a condition that says if applications is returned, replace it with Global Trade SV... Does this help? If the existing formula can be modified then that would be even better... Thanx "JulieD" wrote: Hi not sure what you're after here, but a formula can not update another cell -only the cell that the formula is in. what is the formula in L3780 ... maybe we can alter this to show Global Trade SV instead of applications Regards JulieD "Dmorri254" wrote in message ... HI, I want to say if L3780 = "applications", then replace it with "Global Trade SV" Since there is a formula in the field, I need to place this as a condition...can anyone help me?? Thanx |
|
#7
|
|||
|
|||
|
EUREKA!!!!!! Girl you are just plain AWESOME!! never thought of that one but
it works ...Thanx so much.... David "JulieD" wrote: Hi try =IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","Global Trade SV",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))) - i'm thinking that this could be neatened up a bit but as it's 12.45am my brains too asleep to see it :) - let me know how you got with this ... Cheers JulieD PS i prefer to use ISNA instead of ISERROR .. it isn't as all encompassing and doesn't hide "unexpected" errors. "Dmorri254" wrote in message ... Hi, Let me explain further....L3780 contains this formula: =IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID( VLOOKUP(H3780,Tivoli,4,FALSE),1,15)) What it is doing is looking at another table and bringing me back some text I get form a query...now we are using a different system but I need to merge information form one system into this one...so in order to remain consistant with MY data, I need the word now used for Global Trade SV (applications) to remain Global Trade SV....so this means in relation to the formula in L3780 is this....TIVOLI,4 brings back Global Trade SV....so instead of modifying the formula, I can use a condition that says if applications is returned, replace it with Global Trade SV... Does this help? If the existing formula can be modified then that would be even better... Thanx "JulieD" wrote: Hi not sure what you're after here, but a formula can not update another cell -only the cell that the formula is in. what is the formula in L3780 ... maybe we can alter this to show Global Trade SV instead of applications Regards JulieD "Dmorri254" wrote in message ... HI, I want to say if L3780 = "applications", then replace it with "Global Trade SV" Since there is a formula in the field, I need to place this as a condition...can anyone help me?? Thanx |
|
#8
|
|||
|
|||
|
Hi David
thanks <vbg glad it's solved .. and yep, it's bedtime now :) Cheers JulieD "Dmorri254" wrote in message ... EUREKA!!!!!! Girl you are just plain AWESOME!! never thought of that one but it works ...Thanx so much.... David "JulieD" wrote: Hi try =IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","Global Trade SV",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))) - i'm thinking that this could be neatened up a bit but as it's 12.45am my brains too asleep to see it :) - let me know how you got with this ... Cheers JulieD PS i prefer to use ISNA instead of ISERROR .. it isn't as all encompassing and doesn't hide "unexpected" errors. "Dmorri254" wrote in message ... Hi, Let me explain further....L3780 contains this formula: =IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID( VLOOKUP(H3780,Tivoli,4,FALSE),1,15)) What it is doing is looking at another table and bringing me back some text I get form a query...now we are using a different system but I need to merge information form one system into this one...so in order to remain consistant with MY data, I need the word now used for Global Trade SV (applications) to remain Global Trade SV....so this means in relation to the formula in L3780 is this....TIVOLI,4 brings back Global Trade SV....so instead of modifying the formula, I can use a condition that says if applications is returned, replace it with Global Trade SV... Does this help? If the existing formula can be modified then that would be even better... Thanx "JulieD" wrote: Hi not sure what you're after here, but a formula can not update another cell -only the cell that the formula is in. what is the formula in L3780 ... maybe we can alter this to show Global Trade SV instead of applications Regards JulieD "Dmorri254" wrote in message ... HI, I want to say if L3780 = "applications", then replace it with "Global Trade SV" Since there is a formula in the field, I need to place this as a condition...can anyone help me?? Thanx |
|
#9
|
|||
|
|||
|
Hi Julie...
One more question....how can I use the UPPER function to make Global Trade all upper case?? =IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","Global Trade",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE))," ",MID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))) "JulieD" wrote: Hi David thanks <vbg glad it's solved .. and yep, it's bedtime now :) Cheers JulieD "Dmorri254" wrote in message ... EUREKA!!!!!! Girl you are just plain AWESOME!! never thought of that one but it works ...Thanx so much.... David "JulieD" wrote: Hi try =IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","Global Trade SV",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))) - i'm thinking that this could be neatened up a bit but as it's 12.45am my brains too asleep to see it :) - let me know how you got with this ... Cheers JulieD PS i prefer to use ISNA instead of ISERROR .. it isn't as all encompassing and doesn't hide "unexpected" errors. "Dmorri254" wrote in message ... Hi, Let me explain further....L3780 contains this formula: =IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID( VLOOKUP(H3780,Tivoli,4,FALSE),1,15)) What it is doing is looking at another table and bringing me back some text I get form a query...now we are using a different system but I need to merge information form one system into this one...so in order to remain consistant with MY data, I need the word now used for Global Trade SV (applications) to remain Global Trade SV....so this means in relation to the formula in L3780 is this....TIVOLI,4 brings back Global Trade SV....so instead of modifying the formula, I can use a condition that says if applications is returned, replace it with Global Trade SV... Does this help? If the existing formula can be modified then that would be even better... Thanx "JulieD" wrote: Hi not sure what you're after here, but a formula can not update another cell -only the cell that the formula is in. what is the formula in L3780 ... maybe we can alter this to show Global Trade SV instead of applications Regards JulieD "Dmorri254" wrote in message ... HI, I want to say if L3780 = "applications", then replace it with "Global Trade SV" Since there is a formula in the field, I need to place this as a condition...can anyone help me?? Thanx |
|
#10
|
|||
|
|||
|
Hi
maybe an easier option: =IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","GLOBAL TRADE SV",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))) if you're talking about elsewhere in the workbook then using EDIT / REPLACE is a better option - Find: Global Trade SV Replace with: GLOBAL TRADE SV Cheers JulieD "Dmorri254" wrote in message ... Hi Julie... One more question....how can I use the UPPER function to make Global Trade all upper case?? =IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","Global Trade",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE))," ",MID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))) "JulieD" wrote: Hi David thanks <vbg glad it's solved .. and yep, it's bedtime now :) Cheers JulieD "Dmorri254" wrote in message ... EUREKA!!!!!! Girl you are just plain AWESOME!! never thought of that one but it works ...Thanx so much.... David "JulieD" wrote: Hi try =IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applicati ons","Global Trade SV",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))) - i'm thinking that this could be neatened up a bit but as it's 12.45am my brains too asleep to see it :) - let me know how you got with this ... Cheers JulieD PS i prefer to use ISNA instead of ISERROR .. it isn't as all encompassing and doesn't hide "unexpected" errors. "Dmorri254" wrote in message ... Hi, Let me explain further....L3780 contains this formula: =IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID( VLOOKUP(H3780,Tivoli,4,FALSE),1,15)) What it is doing is looking at another table and bringing me back some text I get form a query...now we are using a different system but I need to merge information form one system into this one...so in order to remain consistant with MY data, I need the word now used for Global Trade SV (applications) to remain Global Trade SV....so this means in relation to the formula in L3780 is this....TIVOLI,4 brings back Global Trade SV....so instead of modifying the formula, I can use a condition that says if applications is returned, replace it with Global Trade SV... Does this help? If the existing formula can be modified then that would be even better... Thanx "JulieD" wrote: Hi not sure what you're after here, but a formula can not update another cell -only the cell that the formula is in. what is the formula in L3780 ... maybe we can alter this to show Global Trade SV instead of applications Regards JulieD "Dmorri254" wrote in message ... HI, I want to say if L3780 = "applications", then replace it with "Global Trade SV" Since there is a formula in the field, I need to place this as a condition...can anyone help me?? Thanx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
Linear Mode
