Support Board
Date/Time: Mon, 25 Nov 2024 04:22:43 +0000
Post From: Question for Spreadsheet Master
| [2014-01-03 05:08:23] |
| Sawtooth - Posts: 4120 |
|
OK, I had a few minutes to try this. You need to reverse the comparison operators in your J23 and J25 formulas. Try this: J23: =IF(J5>0,ROUND(J9-50*J21,4),0) J25: =IF(J5<0,ROUND(J9+50*J21,4),0) J26: =ABS(J5) J29: =AND(ABS(J5)<>J3,J3>0) L3: =AND($J$5>0,$J$3=0) N3: =AND($J$5<0,$J$3=0) |