Syntax For Conditional Formula

[Dmorri254]

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

 

[JulieD]

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

 

[K.S.Warrier]

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]

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]

Hi

try
=IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applications","Global
Trade
SV",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID(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]

Thanx I will try it .....and let you know..get some sleep..

CIAO

 

[Dmorri254]

EUREKA!!!!!! Girl you are just plain AWESOME!! never thought of that one but
it works ...Thanx so much....

David

 

[JulieD]

Hi David

thanks <vbg> glad it's solved .. and yep, it's bedtime now

Cheers
JulieD

 

[Dmorri254]

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)),"",MID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applications","Global
Trade",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15)))

 

[JulieD]

Hi

maybe an easier option:

=IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID(VLOOKUP(H3780,Tivoli,4,FALSE),1,15))="applications","GLOBAL
TRADE
SV",IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",MID(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