what does the +1 do in =INT(6*A2)+1?

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Chantel,

it should be to round up eg.

if you have 1.34 on A2 it will return 9

because 1.34*6 = 8.04
int(8.04) = 8
8+1=9

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"chantel" escreveu:
 
Let's say A2=2.125
A3 =INT(6*A2) The result will be 12. When you add 1, the result will be 13
 
Hi,
Looks to me like it does the same thing as the ROUNDUP function.
The INT function returns the integer part of 6*A2 and then 1 is added to it.
=ROUNDUP(6*A2) would yield the same result.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Avoiding redundant calculations 7
I need help with a Function 0
Excluding Repeating Numbers Help!1 5
INT Function Returns 1 2
Rand between 1 and 50 9
how do I get a result if one cell is X and the 2nd cell is Y where 5
Counting something 5
IF AND question 2

Back
Top