Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater than..
Please would someone help me.. I am trying to enter a formula to return a
value, in another cell, if a cell is greater than or less than a specific value. eg: if the value in cell a1 is less than 600 return value of 0 in cell a2, or if greater than 600 caluculate the difference between a1 and 600 and return the result in a2. Many thanks Eclaires |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater than..
try
=if(a1=600,a1-600,0) -- Don Guillett Microsoft MVP Excel SalesAid Software "Eclaires" wrote in message ... Please would someone help me.. I am trying to enter a formula to return a value, in another cell, if a cell is greater than or less than a specific value. eg: if the value in cell a1 is less than 600 return value of 0 in cell a2, or if greater than 600 caluculate the difference between a1 and 600 and return the result in a2. Many thanks Eclaires |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater than..
In Cell A2 enter
=IF(A1600,A1-600, 0) HTH "Eclaires" wrote: Please would someone help me.. I am trying to enter a formula to return a value, in another cell, if a cell is greater than or less than a specific value. eg: if the value in cell a1 is less than 600 return value of 0 in cell a2, or if greater than 600 caluculate the difference between a1 and 600 and return the result in a2. Many thanks Eclaires |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater than..
=IF(A1<600,0,A1-600)
or =MAX(A1-600,0) Strictly, you haven't specified what you want if A1 is *equal* to 600, but I've guessed. -- David Biddulph "Eclaires" wrote in message ... Please would someone help me.. I am trying to enter a formula to return a value, in another cell, if a cell is greater than or less than a specific value. eg: if the value in cell a1 is less than 600 return value of 0 in cell a2, or if greater than 600 caluculate the difference between a1 and 600 and return the result in a2. Many thanks Eclaires |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater than..
=IF(A1<600,0,A1-600)
or =MAX(A1-600,0) Strictly, you haven't specified what you want if A1 is *equal* to 600, but I've guessed. Since A1-600 equals 0 when A1 equals 0, would it have been possible for you to have guessed wrong?<g Rick |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
greater than..
The OP *may* have wanted something completely different (neither 0 nor
A1-600), but I was relatively confident in guessing in this case. :-) -- David Biddulph "Rick Rothstein (MVP - VB)" wrote in message ... =IF(A1<600,0,A1-600) or =MAX(A1-600,0) Strictly, you haven't specified what you want if A1 is *equal* to 600, but I've guessed. Since A1-600 equals 0 when A1 equals 0, would it have been possible for you to have guessed wrong?<g Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If sum greater than 12 use 12 | Excel Discussion (Misc queries) | |||
Greater Than but Less than | Excel Worksheet Functions | |||
IF greater than Zero | Excel Worksheet Functions | |||
IF greater than...IF less than....====== | Excel Discussion (Misc queries) | |||
Greater then/less then | Excel Worksheet Functions |