Syntax For Conditional Formula

D

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
 
J

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

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","")
 
D

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
 
J

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.
 
D

Dmorri254

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

David
 
J

JulieD

Hi David

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

Cheers
JulieD
 
D

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)))
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top