Greater than formula!

  • Thread starter Thread starter nekteo
  • Start date Start date
N

nekteo

i hv a question...

Is there any formula in excel that can convert a certain number to a number
that is greater than the previous number, with the smallest difference which
is also an integer number? for example:


23.56 convert to 24
24.00 convert to 25
23.12 convert to 24
19.00 convert to 20
42.10 convert to 43

HELP ME!!!
 
It looks like you could just add one and take the integer portion:

=int(a1+1)

If A1 held the original number.
 

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

Convert QuickBooks time format to excel to calculate 2
SMALL function to find X smallest number greater than Y 6
setting up sequence sets with only 3 repeat once in excel 2
Greater Than 6
Converting time to decimal format 17
Countif with two criteria 2
Excel Need Countifs Formula Help 0
Convert 29.08 hours (shown in decimal form) to time shown in "hh:m 1

Back
Top