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
I did a simple replication of your sheet and it works for me for...
-
- 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,710.9 |
Change
11.800(0.14%) |
Mkt cap ! n/a | |||
| Open | High | Low |
| 8,699.1 | 8,716.6 | 8,699.1 |
| XAO (ASX) Chart |
