Try this mate:=IF(ISBLANK(E5)=TRUE,0,IF(F5="Open",IF(I5<1000,10,19.95),(IF(I5<1000,10,19.95)+IF(G5*L5<1000,10,19.95))))
You can reference to two separate cells for brokerage variation if you want to improve this.
Cheers
CC
Short Term Trading Week Starting: 14 Jan, page-50
-
- There are more pages in this discussion • 119 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,715.3 |
Change
16.200(0.19%) |
Mkt cap ! n/a | |||
| Open | High | Low |
| 8,699.1 | 8,727.7 | 8,699.1 |
| XAO (ASX) Chart |
