| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Minimum function | Excel Discussion (Misc queries) | |||
| Querying a range returned by another function | Excel Worksheet Functions | |||
| Format numbers returned in the function CONCATENATE | Excel Discussion (Misc queries) | |||
| minimum function | Excel Worksheet Functions | |||
| Using the returned value of a function | New Users to Excel | |||
Threaded Mode
