Including number format in formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zilbandy - 05 Nov 2006 15:21 GMT

I have a simple "if/then/else" formula that I would like to display
the result of the "else" portion with no decimal places showing,
instead of the default value of the cell. Can I include the format in
the formula? Here is my formula:

=IF(D12>75,D12/E12,D12)

Thanks,

Signature

Zilbandy - Tucson, Arizona USA <zil@zilbandyREMOVETHIS.com>
Dead Suburban's Home Page: http://zilbandy.com/suburb/
PGP Public Key: http://zilbandy.com/pgpkey.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Reply to this Message

VBA Noob - 05 Nov 2006 15:29 GMT

Hi,

Try =IF(D12>75,D12/E12,INT(D12))

or replace Int with roundup or rounddown

VBA Noob

> I have a simple "if/then/else" formula that I would like to display
> the result of the "else" portion with no decimal places showing,
[quoted text clipped - 10 lines]
> PGP Public Key: http://zilbandy.com/pgpkey.htm
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Reply to this Message

Don Guillett - 05 Nov 2006 15:38 GMT

=TEXT(IF(D12>75,D12/E12,D12),"#,###")

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I have a simple "if/then/else" formula that I would like to display
> the result of the "else" portion with no decimal places showing,
[quoted text clipped - 4 lines]
>
> Thanks,

Reply to this Message

Lori - 06 Nov 2006 15:01 GMT

Or use a custom number format like: [>75]0.00;0

Reply to this Message

Rate this thread: