I am writing a formula that references multiple cells as the possible source
cell depending on certain parameters being met. My question is whether
anyone knows how to maintain the formatting in the display cell? My possible
source cells all contain different number formats (i.e. -1234.0 and
##00.0E-+00). Is there a way to write this into the formula, or is there a
formatting option that allows you to keep the source cell's format? Any help
would be great!