500 min formula

I hope I can explain this correctly. 

I am trying to convert numbers that are less than 500 in a cell column to 500. But if a number in said cell column is 500 or above, I would need it to stay that actual number. I would also like the converted/acutal numbers to be in a different column from the column that I key them into.

example: If I key 345 into a cell than in a diffent cell it would be converted to 500. If I key 604 into the came cell column than it would not convert to anything and that actual number would roll into the column witht he rest of the converted column. 

Please let me know if I can clear this up in anyway so that I can get the answer I am looking for. 

 

Thanks for you time

By: Jeremy

Leave a Reply

Your email address will not be published. Required fields are marked *