Using subsripts inside a formula
Using subsripts inside a formula
(OP)
I use text and subscripts for variable names as plain text to document my spreadsheets. In this case, my documentation "disappears" based on a true/false result in another cell. In my example below, I would like to use a subscript for the P in the formula below. Is there a simple way to do this or do I just need to be content with using a lowercase P?
=IF(K18=1,"","Fp =")
=IF(K18=1,"","Fp =")





RE: Using subsripts inside a formula
RE: Using subsripts inside a formula
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Using subsripts inside a formula
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Using subsripts inside a formula
Good idea, which I will explore. (At the risk of exposing my ignorance, I have to admit I had never heard of picture links. Luckily the guru-issimo has something about them: see http://j-walk.com/ss/excel/usertips/tip039.htm)
Your first suggestion, using conditional formatting, could be used on the example SteveGregory gives. However it cannot be extended to the more general (and, in my cases at least, more common)
=IF(K18=1,"One formatted string","Another formatted string")
RE: Using subsripts inside a formula
RE: Using subsripts inside a formula
I may try the picture link idea for some more complex formatting in the future.