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 |
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 |