software

=IF(D3gt;0,LOG(C3/F3),quot;gt;quot;amp;LOG(C3/10)) gives me the two options that I want.
Thanks to all who responded. Now, the first part is rounded to 1 decimal
place, ie 0.0, because I chose so in custom mode. When the second part is
true, however, I loose the custom formatting and get several decimal places
added. How do I prevent this?

Try this:

=IF(D3gt;0,LOG(C3/F3),quot;gt;quot;amp;TEXT(LOG(C3/10),quot;#.#quot;))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;Kaputaquot; gt; wrote in message
...
gt; =IF(D3gt;0,LOG(C3/F3),quot;gt;quot;amp;LOG(C3/10)) gives me the two options that I want.
gt; Thanks to all who responded. Now, the first part is rounded to 1 decimal
gt; place, ie 0.0, because I chose so in custom mode. When the second part is
gt; true, however, I loose the custom formatting and get several decimal
places
gt; added. How do I prevent this?Hi Kaputa,

=IF(D3gt;0,LOG(C3/F3),quot;gt;quot;amp;TEXT(LOG(C3/10),quot;0.0quot;))

Ed Ferrero
Microsoft Excel MVP
www.edferrero.com

gt; =IF(D3gt;0,LOG(C3/F3),quot;gt;quot;amp;LOG(C3/10)) gives me the two options that I want.
gt; Thanks to all who responded. Now, the first part is rounded to 1 decimal
gt; place, ie 0.0, because I chose so in custom mode. When the second part is
gt; true, however, I loose the custom formatting and get several decimal
gt; places
gt; added. How do I prevent this?