Rounding

  • Thread starter Thread starter Roger R
  • Start date Start date
R

Roger R

I have a colum of numbers that ranges from 0 to over 4000,
is there a simple way to have any number in that colum
read 100+ if it is in fact over 100. This sheet is used
for my inventory and I send it out to many differnt users,
and I don't care to have them know the exact inventory of
any given item.
 
Hi Roger
you could try the following:
- add a helper column
- insert the formula:
=IF(A1>100,"100+",A1)
and copy down (if col. A stores your amoun)
- hide the original column and protect your worksheet

Note. Excel's security meachnism are very weak
 
One way:

Format/Cells/Number/Custom [<=100]General;"100+"


Note that this will not prevent them from seeing the values in the
formula bar, or using =A1, say, in another (non-formatted) cell. If you
really don't want your users to see the inventory, send them PDF of your
sheet.
 
Back
Top