| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If greater than 5
Need a formula - I know it's simply - just can't get it.
If A1 is greater than 5, then B1 = 5 If A1 is less than 5, B1 should equal the amount in A1 CarolAnn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If formula: if A1 is greater than B1 and A1 is greater than zero.. | Excel Discussion (Misc queries) | |||
| greater than, less than, and in between | Excel Discussion (Misc queries) | |||
| greater then less then | Excel Worksheet Functions | |||
| if greater then 99 then 1 if greater then 199 then two | Excel Worksheet Functions | |||
| IF greater than...IF less than....====== | Excel Discussion (Misc queries) | |||
Threaded Mode
