Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than or equal to (Plus or minus)
Here is my formula.
=IF(Sheet1!J5=$J$4,0,(Sheet1!$J$4-Sheet1!J5)*Sheet1!$J$1) It is perfect, except it doesn't have one final step. What I need it to do is be able to do that ONLY if it is greater than or less than by a specified amount. So there needs to be a modification of ...Sheet!J5< (but by 100 or any other number that I set) $J$4,... Thanks so much for the help! Brandon |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than or equal to (Plus or minus)
Kind of got lost towards the end on exacly what conditions you're looking
for. As far as the greater than or less than part, try using OR(Sheet!J5<Amount,Sheet!J5Amount) as your condition. Sorry I don't know exactly where you wanted that so can't stick it into the formula for you. -Simon "Brandon" wrote: Here is my formula. =IF(Sheet1!J5=$J$4,0,(Sheet1!$J$4-Sheet1!J5)*Sheet1!$J$1) It is perfect, except it doesn't have one final step. What I need it to do is be able to do that ONLY if it is greater than or less than by a specified amount. So there needs to be a modification of ...Sheet!J5< (but by 100 or any other number that I set) $J$4,... Thanks so much for the help! Brandon |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Greater than or equal to (Plus or minus)
Maybe, if you want to check to see if there's a difference of less than 100...
=if(abs(sheet1!$j$5-$j$4)<100,"within a hundred formula","= 100 formula") You could change that 100 to point at any cell you want. Brandon wrote: Here is my formula. =IF(Sheet1!J5=$J$4,0,(Sheet1!$J$4-Sheet1!J5)*Sheet1!$J$1) It is perfect, except it doesn't have one final step. What I need it to do is be able to do that ONLY if it is greater than or less than by a specified amount. So there needs to be a modification of ...Sheet!J5< (but by 100 or any other number that I set) $J$4,... Thanks so much for the help! Brandon -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
First occurance greater than or equal to a specified value | Excel Worksheet Functions | |||
Matching Values from an Array | Excel Worksheet Functions | |||
Formula which is greater tahn or equal to zero | Excel Worksheet Functions | |||
Vlookup but also equal to and greater than? | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |