How do I set a minimum value to be returned from IF function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following IF function in column D of a spreadsheet:
IF(c1>10,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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to determine the minimum value with given condition? 2
i want to know formulas in MS-Excel2003 3
Can an If statement return a formula for false? 1
How to determine the minimum difference between values? 3
How do you initialize the values in a circular reference? 2
Conditonal formatting problem! 1
MAX then return value? 10
How to copy the function SUM but offseted in 7 columns 2

Back
Top