Under Limit

[GhostKill]

Hello Friends,
This is Jay from India, first of all, thank you for your valuable suggestion, advice, and everything regarding MS Excel, it has been helped a lot with my daily work.
I required your valuable suggestion for the following problem.

I have numbers in column A and I required the newly revised number in Column B, but there is the limit of NMT 60.0, so can you suggest me any formula, so I can bring down all numbers in Column A above 60.0 to under 60.0 as revised number in Column B
Find attached Excel for problem.

[Pete_UK]

You can use this formula in B2:

=MIN(60,A2)

then copy down as required.

Hope this helps.

Pete

[PaulM100]

So you want to limit the cell value to 60? meaning that you cannot enter something greater than 60? like in the file I've attached?

[GhostKill]

Thank you very much Pete_UK

[GhostKill]

No, I want to convert the value from Coumn A automatically to under 60, whichever cell has it.

[PaulM100]

Like this?

IF(A2>60,60,A2)

[GhostKill]

THANK YOU PaulM100

[Pete_UK]

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete