I did a simple replication of your sheet and it works for me for the third row too.I used the following formula:
=IF(ISBLANK(E5)=TRUE,0,IF(F5="Open",IF(I5<1000,$E$19,$E$20),(IF(I5<1000,$E$19,$E$20)+IF(G5*L5<1000,$E$19,$E$20))))
It works fine if the buying price exceeds $1000.
Cheers CC
Short Term Trading Week Starting: 14 Jan, page-58
-
- There are more pages in this discussion • 111 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
Add XAO (ASX) to my watchlist
 (20min delay)
|
|||||
|
Last
8,612.6 |
Change
-48.600(0.56%) |
Mkt cap ! n/a | |||
| Open | High | Low |
| 8,661.2 | 8,682.0 | 8,606.8 |
| XAO (ASX) Chart |
