Superscript.

Nigel Martin · May 16th, 2002, 05:30 AM

I have a spreadsheet whereby an answer is produced and the next cell has to specify the units. These units have to change according to the answer in the first cell. I have used IF statements - this works fine but the units are all normally formated e.g. I need to display metre cubed and metres squared. So to re-cap is there a way you format part of a formula - =IF(A1=2,"m3","m2") only the 3 and the 2 need to be superscripted. Any ideas ?

gareth · May 16th, 2002, 05:32 AM

Try this url it will help you to do almost anything you want to do in excel

asap-utilities.com

Mark O'Brien · May 16th, 2002, 07:47 AM

If you feel like messing about with VBA for a more automated way of creating subscripts and superscripts have a look at this thread here, (the last piece of code I supplied works best):

http://www.mrexcel.com/board/viewtop...rum=2&start=10

Nigel Martin · May 16th, 2002, 08:39 AM

Cheers.

May 16th, 2002, 05:32 AM	#2
gareth Board Regular Join Date: Apr 2002 Location: Cape Town,South Africa Posts: 234	Try this url it will help you to do almost anything you want to do in excel asap-utilities.com __________________ Regards Gareth Visit The Excel Maniacs :<>: Have a Chat! :<>: Free Stuff!

May 16th, 2002, 07:47 AM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	If you feel like messing about with VBA for a more automated way of creating subscripts and superscripts have a look at this thread here, (the last piece of code I supplied works best): http://www.mrexcel.com/board/viewtop...rum=2&start=10 __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 05:30 AM	#1
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	I have a spreadsheet whereby an answer is produced and the next cell has to specify the units. These units have to change according to the answer in the first cell. I have used IF statements - this works fine but the units are all normally formated e.g. I need to display metre cubed and metres squared. So to re-cap is there a way you format part of a formula - =IF(A1=2,"m3","m2") only the 3 and the 2 need to be superscripted. Any ideas ?

May 16th, 2002, 08:39 AM	#4
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	Cheers.