View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sairam
 
Posts: n/a
Default 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.