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

3 thoughts on “500 min formula

  1. ig

    It’s very trouble-free to find out any matter on web
    as compared to textbooks, as I found this post at this web site.

  2. Fay

    Your way of describing the whole thing in this piece of writing is
    genuinely fastidious, every one can simply be aware of it,
    Thanks a lot.

  3. Floy Kemick

    After study a few of the blog posts on your website now, and I truly like your way of blogging. I bookmarked it to my bookmark website list and will be checking back soon. Pls check out my web site as well and let me know what you think.

Comments are closed.