Formula Help with Rounding

[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.

 

[RagDyer]

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.

 

[Trevor Shuttleworth]

Marc

one way:

=IF(AND(A1>=8,A1<=9),8,IF(A1>9,A1-1,A1))

Regards

Trevor

 

[Marc]

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)