You can reference cells for brokerage like...

ANNOUNCEMENT SPONSORED BY PLUS500
ANNOUNCEMENT SPONSORED BY PLUS500
CFD TRADING PLATFORM
CFD Service. Your Capital is at risk
CFD TRADING PLATFORM CFD Service. Your Capital is at risk
TRADE NOW
TRADE NOW
ANNOUNCEMENT SPONSORED BY PLUS500
CFD TRADING PLATFORM CFD Service. Your Capital is at risk
TRADE NOW
  1. ColonialCousin
    286 Posts.
    lightbulb Created with Sketch. 73
    clock Created with Sketch.
    15/01/19
    12:23
    Post #: 37118233
    You can reference cells for brokerage like this:

    =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/1407979-ccb0c67a1dc1ba46d7e6bfb8f6bfcc8d.jpg

    Cheers

    CC

    Likes Created with Sketch. 1  Upvote
    Stroke 3 Created with Sketch. Comments Created with Sketch. Reply

  2. Top Stories

 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.