Unable to round up and down the numbers

[rush2rajen]

Hi Excel Gurus,

I was trying to round down the no which I had done manually but I am unable to write a formula for the same.

Please help to write a formula which will calculate as per the one written manually.


Thanks
Raj

 

[tomas]

Hi the last one differs because it doesn't follow the logic of predecessors

 

[rush2rajen]

Thanks Tomas