View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Cash Neil Cash is offline
external usenet poster
 
Posts: 3
Default Is there a way to use subscripts in my formulas?

I use a lot of variables with subscripts. And would like the formatting to
follow the output when I put these in formulas.

i.e. =if(E180,"pr = 7","pr = 0")

I would like the "r" in pr be subscripted when it calculates the formula.
So far I've noticed that it removes all formatting when the formula
calculates. Is there a way around this?

Thanks in advance!