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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If greater than 5
You dont say what you want to do if A1 = 5. Im assuming if it = 5 then return 5
=IF(A1=5,5,A1) "Carolan" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If greater than 5
If A1 is greater than 5...
If A1 is less than 5... What if A1 **IS** 5? See if this does what you want. =MIN(A1,5) -- Biff Microsoft Excel MVP "Carolan" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If greater than 5
Sorry, I'm trying to say if what is in Column A is 5 or greater, then in
Column B the result should be 5. If what is in column A is less than 5, Column B should equal the exact same amount A B 1 5.5 5 2 4.2 4.2 "T. Valko" wrote: If A1 is greater than 5... If A1 is less than 5... What if A1 **IS** 5? See if this does what you want. =MIN(A1,5) -- Biff Microsoft Excel MVP "Carolan" wrote in message ... 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 . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If greater than 5
Ok, the formula I suggested will do what you want.
-- Biff Microsoft Excel MVP "Carolan" wrote in message ... Sorry, I'm trying to say if what is in Column A is 5 or greater, then in Column B the result should be 5. If what is in column A is less than 5, Column B should equal the exact same amount A B 1 5.5 5 2 4.2 4.2 "T. Valko" wrote: If A1 is greater than 5... If A1 is less than 5... What if A1 **IS** 5? See if this does what you want. =MIN(A1,5) -- Biff Microsoft Excel MVP "Carolan" wrote in message ... 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 . |
Reply |
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) |