Setting a minimum value for a cell.

Hi guys,


I would like to set a formula in a particular cell so that everytime a value in that cell is less than 1 (<1) it gets replaced to 1 automatically.


For example, in case of below my Payable tax amount comes to 0.7. However, minimum amount I have to pay is 1. Is there any formula which I can apply here so whenever my calculation for payable amount comes under 1 it gets automatically replaced to 1?


Cheers!


MacBook Pro 13", macOS 10.14

Posted on Apr 28, 2019 5:09 AM

Reply
4 replies

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.

Setting a minimum value for a cell.

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