Help With The Upper Function
 

Hello,

I need some help with using the UPPER function....in this formula I need to
convert the text "Global Trade" to upper case, where inside the formula do I
place the UPPER funtion?

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

Thanx

=IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,
FALSE),1,15))="applications",UPPER("Global
Trade"),IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)), "",MID(VLOOKUP(H3780,Tivol
i,4,FALSE),1,15)))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dmorri254" wrote in message
...
Hello,

I need some help with using the UPPER function....in this formula I need
to
convert the text "Global Trade" to upper case, where inside the formula do
I
place the UPPER funtion?


=IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(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)))

Thanx

GREAT that worked...thank you so much...still learning nesting
functions...gets confusing...okay once more question...in this case, I need
what is returned from tivoli,5 in upper case where would I place the UPPER
function? Would it go somewhere before or after MID?

=IF(ISERROR(VLOOKUP(H3780,Tivoli,5,FALSE)),"",MID( VLOOKUP(H3780,Tivoli,5,FALSE),1,9))

"Bob Phillips" wrote:

=IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,
FALSE),1,15))="applications",UPPER("Global
Trade"),IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)), "",MID(VLOOKUP(H3780,Tivol
i,4,FALSE),1,15)))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dmorri254" wrote in message
...
Hello,

I need some help with using the UPPER function....in this formula I need
to
convert the text "Global Trade" to upper case, where inside the formula do
I
place the UPPER funtion?


=IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(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)))

Thanx

=IF(ISERROR(VLOOKUP(H3780,Tivoli,5,FALSE)),"",UPPE R(MID(VLOOKUP(H3780,Tivoli,5,FALSE),1,9)))


On Fri, 5 Nov 2004 11:40:03 -0800, Dmorri254
wrote:

GREAT that worked...thank you so much...still learning nesting
functions...gets confusing...okay once more question...in this case, I need
what is returned from tivoli,5 in upper case where would I place the UPPER
function? Would it go somewhere before or after MID?

=IF(ISERROR(VLOOKUP(H3780,Tivoli,5,FALSE)),"",MID (VLOOKUP(H3780,Tivoli,5,FALSE),1,9))

"Bob Phillips" wrote:


=IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(VLOOKUP(H3780,Tivoli,4,
FALSE),1,15))="applications",UPPER("Global

Trade"),IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)), "",MID(VLOOKUP(H3780,Tivol
i,4,FALSE),1,15)))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dmorri254" wrote in message
...
Hello,

I need some help with using the UPPER function....in this formula I need
to
convert the text "Global Trade" to upper case, where inside the formula
do
I
place the UPPER funtion?



=IF(IF(ISERROR(VLOOKUP(H3780,Tivoli,4,FALSE)),"",M ID(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)))

Thanx