[Solved] Show result with no decimal places

[davidflynn9]

This code does what I want but im stuggling to figure out how to make it show nothing after the decimal.

Code: Select all

=IF(ISERROR(C4/E4)*100;"";(C4/E4)*100)

like it reads out my number example 32.333333 i would like it make it only show 32

[FJCC]

Select the cell and then use the menu Format -> Cells to set the number of decimal places on the Numbers tab.

[RusselB]

FJCC's suggestion changes the display, but not the actual number.
If you want the actual number changed, wrap the last term of your IF in an INT function.

[davidflynn9]

Thank you all that solved my problem!