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

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

Why not just look in the help index for MIN

--
Don Guillett
SalesAid Software

"KW" wrote in message
...
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