How do I set a maximum value to a cell in Numbers?

I have a cell which references a percentage in the previous cell, example: =TRUNC(C2*1000,0)
So, the cell that it references (C2) is a percentage, anything from 0% up. The issue that I have is that I want to limit the cell's response to the percentage by setting the maximum at 1000. So, if the percentage in the cell is 104%, I don't want the cell to return 1040, I want it to return a maximum of 1000. The MAX function in Numbers is just for searching cells to find the highest numeric value, and there is no IF THEN statements that I can make in the cell, you can do IF, but it just returns a true or false value. I hope I provided enough info for someone to be able to help me out. I have been trying to figure out if there is a mathematical way that I can limit the response to 0-1000 and still have it be accurate to the percentage but I have not come across anything yet.

Thanks

2.0 Ghz iMac Silver, Mac OS X (10.5.2), Latest version of Numbers

Posted on May 13, 2008 8:32 AM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How do I set a maximum value to a cell in Numbers?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.