Try that with 29


--


Regards,


Peo Sjoblom




"pablo bellissimo" wrote in
message ...
try entering the following formula in B1

=ROUNDDOWN(A1,-1)&"-"&ROUNDDOWN(A1,-1)+5

HTH

"tjb" wrote:

In cell A1, I have a formula giving me a number 31.
In cell B1, I need to enter text saying "30-35"

This formula needs to change based on the content of cell A1. For
example,
if A1 said 20, then B1 should read "15-20", if A1 said 67, then B1 should
read "65" and so on.

I know this is possible but I've forgotten the formula. Thanks all!