XAO
Click for more information
0.56% 8,612.6 all ordinaries

I did a simple replication of your sheet and it works for me for...

  1. ColonialCousin
    286 Posts.
    lightbulb Created with Sketch. 73
    clock Created with Sketch.
    15/01/19
    12:36
    Post #: 37118426
    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))))

    https://hotcopper.com.au/data/attachments/1407/1407994-fb44353c2e7ecc33ec3c912459c77dcf.jpg

    It works fine if the buying price exceeds $1000.

    Cheers CC



    XAO Value at posting: 5,852.2
    Likes Created with Sketch. 3  Upvote
    lightbulb Created with Sketch.  Great analysis
    Stroke 3 Created with Sketch. Comments Created with Sketch. Reply

  2. Top Stories

 
watchlist Created with Sketch. 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
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.