How do I set a minimum result value in an Excel formula? IE 100
I need to set the result column of a calculation in Excel to always give me a
result greater than 100, or of 100 or greater. How can I set the formula in the result cell to always finish with a result 100. I am aware this will create a circular reference and I know how to set that up in Excel. I want it to keep rolling over results untill it goes over 100. Then stop at 100 or more. |
All times are GMT +1. The time now is 11:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com