Thread: How do I set a minimum value to be returned from IF function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KW KW is offline
external usenet poster
  
Posts: 10
Default How do I set a minimum value to be returned from IF function
I have the following IF function in column D of a spreadsheet:
IF(c110,c1*2,c1*3). I need to also specify that any value in column D that
is less than 6 should equal 6. Trying to set this criteria gives me a
circular reference error. Can I use a circular reference to set a minimum
value on this column?

KW
Reply With QuoteReply With Quote