Displayed number format

[Kevin]

I have a conditional statement that looks at the value in one cell, then
displays a message in another cell that addresses the result of the first
cell. The function I am using is as follows:

=IF(F3>0,"Increased by: "&F3&" C/Ft3",IF(F3=0,"No Change","Decreased by:
"&ABS(F3)&" C/Ft3"))

The result of this is the number in cell F3 which in F3 is formated as
scientific is displayed as "Increased by: .0001122355 C/Ft3".

I would like it to be displayed as "Increased by 1.12E-04 C/Ft3".

Is these a way to do this?

Thanks!

 

[Jason Morin]

=IF(F3>0,"Increased by: "&TEXT(F3,"0.00E+00")&" C/Ft3",IF
(F3=0,"No Change","Decreased by: "&ABS(F3)&" C/Ft3"))

HTH
Jason
Atlanta, GA

 

[Kevin]

Jason,

Thanks for the help!

Kevin

=IF(F3>0,"Increased by: "&TEXT(F3,"0.00E+00")&" C/Ft3",IF
(F3=0,"No Change","Decreased by: "&ABS(F3)&" C/Ft3"))

HTH
Jason
Atlanta, GA