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