Including number format in formula

[Zilbandy]

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,

 

[VBA Noob]

Hi,

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

or replace Int with roundup or rounddown

VBA Noob

 

[Don Guillett]

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

 

[Lori]

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