rounding

[david hasslehof]

I have a lookup function and want to round some numbers to a nearest interger to make it easier. If somebody wanted to enter 1600 I want it to round the lookup to 1500 but keep the 1600 visable and just display the value of 1500, is there any way I can do this?

 

[Peter_SSs]

I have a lookup function and want to round some numbers to a nearest interger to make it easier. If somebody wanted to enter 1600 I want it to round the lookup to 1500 but keep the 1600 visable and just display the value of 1500, is there any way I can do this?

Could you try to explain this again giving some more information about what cells you are dealing with and what your current lookup formula is?