Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 04 May 2024 08:14:59 +0000
Post From: Question for Spreadsheet Master
| [2014-01-03 05:08:23] |
| Sawtooth - Posts: 3993 |
|
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) |