Thread: Formula help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Formula help

On May 13, 9:33*am, Anonymous wrote:
I need a formula that will round down a number if it is
less than .75 and round up if it is greater. *So, for
example, 2.69 would round down to 2 and 2.89 would round
up to 3.


If your original number is in A1, ostensibly:

=INT(A1)+(MOD(A1,1)=0.75)

However, there are many values that might display as x.75 in A1, but
which round down to x using that formula. Perhaps you will be happier
with the results from:

=INT(A1)+(ROUND(MOD(A1,1),2)=0.75)