Howdy @rick64 tag @mike68 @picastoc reckon keep it here as we...

Howdy @rick64

tag @mike68 @picastoc

reckon keep it here  as we can see the column and row labels

Your requirements:

"I basically need to change the brokerage from $10 to $19.95 if trade is worth over $1000, as that is what Commsec charge.

IE I buy 999 shares in ANO for $1.00 total is $999 plus $10 brokerage.

I sell 999 shares in ANO for $1.24 total is $1238.76 less brokerage of $19.95.

I somehow cannot get my sheet to reflect this change in brokerage costs.

This is the current formula for brokerage.

=IF(ISBLANK(E5)=TRUE,0,IF(F5="Open",$E$19,$E$19*2))"