Dmorri254

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Averaging function	Sarah	Excel Discussion (Misc queries)	0	January 18th 05 04:09 PM
Excel function help facilities	RPS	Excel Discussion (Misc queries)	1	December 8th 04 02:36 AM
I cant use englisch function names in a swedich version of excel	PE	Excel Discussion (Misc queries)	2	December 7th 04 01:00 AM
UPPER Function	Dmorri254	Excel Worksheet Functions	1	November 5th 04 07:57 PM
need to save values from a function before it changes	Ron	Excel Worksheet Functions	1	October 29th 04 06:29 AM

All times are GMT +1. The time now is 11:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us