Formula Help with Rounding

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

I am tring not to do this in multiple steps:

Any number between 8 and 9 to rounddown to 8 and if the number is
anything above 9 to subtract one.

Thanks in advance.
 
Try this:

=IF(A1>9,A1-1,MIN(A1,8))

Anything less then 8 will be returned.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I am tring not to do this in multiple steps:

Any number between 8 and 9 to rounddown to 8 and if the number is
anything above 9 to subtract one.

Thanks in advance.
 
Thanks for your help, I managed to get it later in the day. I had to d
the following to always keep anything between 8 to 8.9 at 8 an
anything at 9 or over is deducted by one.

IF(AND(B25>=8,B25<9),ROUNDDOWN(B25,0),IF(B25>=9,B25-1,B25+0)
 
Back
Top