LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Air Lancer
 
Posts: n/a
Default Displays statements in Subcript or superscript using "If" formula

Hi all,

how do i create a "if" statement that displays words in subcript or
superscript?

e.g. = if (A1A2, "Pa Pb", "Pb Pa"), where the "a" and "b" should be
displayed as subscripts to "P".

thk.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Linking two IF statements together trixma Excel Discussion (Misc queries) 2 September 29th 05 06:07 AM
how do i superscript part of a cell in MS Excel? allan Excel Discussion (Misc queries) 8 July 20th 05 10:37 PM
how do i superscript part of a cell in MS Excel? allan Excel Discussion (Misc queries) 0 July 13th 05 08:12 PM
Nested IF statements John Simons Excel Worksheet Functions 14 February 16th 05 06:17 AM
Formula window displays correct answer while cell displays incorre MMV Excel Worksheet Functions 3 November 10th 04 09:28 PM


All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"