specify a certain cell format as part of an "if" statement
 

How do I specify a specific cell format (e.g., scientific) as part of an if
statement?

specify a certain cell format as part of an "if" statement
 

You don't, unless you want to use the TEXT() function.
--
David Biddulph

Zeev Maoz wrote:
How do I specify a specific cell format (e.g., scientific) as part of
an if statement?

specify a certain cell format as part of an "if" statement
 

Are you wanting to write VBA code (macro) to do that or did you want to do
this without code. The short answer is that it can not be done without code.
The closest you get is conditional formats which can modify cell formats, but
number formats are not included in the list of attributes accessable via
conditional formatting.
--
HTH...

Jim Thomlinson


"Zeev Maoz" wrote:

How do I specify a specific cell format (e.g., scientific) as part of an if
statement?