ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I set a minimum result value in an Excel formula? IE 100 (https://www.excelbanter.com/excel-worksheet-functions/63468-how-do-i-set-minimum-result-value-excel-formula-ie-100-a.html)

sairam

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