| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minimum Cell Value
Hi,
Wondered if anybody could help me.. I need a cell to display a minimum value of £90 and to intergrate that into this formula: =IF(Employees<21,"£2000",IF(Employees<51,"£2500",I F(Employees<101,"£3000",IF (Employees<251,"£5000",IF(Employees<376,"£7000",IF (Employees<501,"£9000","£0 ")))))) So, if the result from the formula is..say, £50...then it is automatically increased to £90. tia :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set a minimum value for a cell | Excel Discussion (Misc queries) | |||
| How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
| cell minimum value of zero ? | Excel Discussion (Misc queries) | |||
| Maximum and minimum cell value | Excel Discussion (Misc queries) | |||
| How can I set a minimum value of zero or -100% in a cell? | Excel Worksheet Functions | |||
Threaded Mode
