Hello Again,
I am looking for an formula on below conditions.
1. More than 300,00 +values then extract 300,000 and get excess amount.
2. More than -300,00 -value then return as is.
3. Less than 300,000 +value then return 0.
4. Less than -300,000 -value then return 0
Example:
328,500
-313,000
5,000
-450,060
-250,000
Output:
28,500
-313,000
0
-450,060
0
Can someone help me to write the formula.
Bookmarks