How can you change the formulas in Excel into simple integers?

Answer 1

If a formula returns a number, you can do some things to show it as an integer, though it will depend what way you want the value. There are three functions that are of use for rounding numbers to zero decimal places. ROUND will round the value to the nearest integer. ROUNDDOWN will round the number down to the value below it. ROUNDUP will round to the number above it. Say your value was in cell A2, then in another cell you could use the following functions:

=ROUND(A2,0)

=ROUNDDOWN(A2,0)

=ROUNDUP(A2,0)

In place of the A2 you could have an actual formula, like an Average function for example:

=ROUND(AVERAGE(A2:A10),0)

You could also use the INT function to get the integer part of the number like this:

=INT(A2)

You can also copy a cell with a formula in it and use Paste Values to convert it to the actual number its result is, and then use one of the rounding functions or the INT function to convert that number to an integer.