| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, Then Values
I am trying to find a formula that will return a value in another cell if the
number is greater than the selected cell. Example: cell A1 is 100 cell A2 is 150 I want the difference of 50 to be returned in cell A3 only if its a greater number. Hope it makes sence. Thanks CMS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If, Then Values
So, if I understand, you want A3 to be the difference of A2 and A1 only if A2
is greater than A1? If so, use this formula in A3: =IF(A2A1,A2-A1,"") Cell A3 will remain blank if A1 is greater than or equal to A2. HTH, Elkar "bassplayerbg" wrote: I am trying to find a formula that will return a value in another cell if the number is greater than the selected cell. Example: cell A1 is 100 cell A2 is 150 I want the difference of 50 to be returned in cell A3 only if its a greater number. Hope it makes sence. Thanks CMS |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If, Then Values
One way:
=IF(A2 A1, A2 - A1, "") In article , bassplayerbg wrote: I am trying to find a formula that will return a value in another cell if the number is greater than the selected cell. Example: cell A1 is 100 cell A2 is 150 I want the difference of 50 to be returned in cell A3 only if its a greater number. Hope it makes sence. Thanks CMS |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If, Then Values
=MAX(A2-A1,0)
"bassplayerbg" wrote: I am trying to find a formula that will return a value in another cell if the number is greater than the selected cell. Example: cell A1 is 100 cell A2 is 150 I want the difference of 50 to be returned in cell A3 only if its a greater number. Hope it makes sence. Thanks CMS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using two values to report multiple values | Excel Discussion (Misc queries) | |||
| Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
| List of values | Excel Discussion (Misc queries) | |||
| Referencing a specific number to more general values in a table. | Excel Worksheet Functions | |||
| Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
Linear Mode
