Help With The Upper Function

[Dmorri254]

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

Thanx

 

[Bob Phillips]

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

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

 

[Myrna Larson]

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