WHC 0.13% $7.63 whitehaven coal limited

=SUMPRODUCT(--(P4>{0;100;150;175;225;300}),(P4-{0;100;150;175;225...

  1. 6,000 Posts.
    lightbulb Created with Sketch. 982
    =SUMPRODUCT(--(P4>{0;100;150;175;225;300}),(P4-{0;100;150;175;225;300}), {0.07;0.055;0.025;0.05;0.1;0.1})
    .
    Put the sale price in cell P4.
    .
    Easy Excel.
    .
    https://hotcopper.com.au/data/attachments/6264/6264027-6650808e0edab1bb416d675ac61f7cdb.jpg
 
watchlist Created with Sketch. Add WHC (ASX) to my watchlist
(20min delay)
Last
$7.63
Change
0.010(0.13%)
Mkt cap ! $6.383B
Open High Low Value Volume
$7.49 $7.65 $7.43 $26.82M 3.533M

Buyers (Bids)

No. Vol. Price($)
2 30420 $7.62
 

Sellers (Offers)

Price($) Vol. No.
$7.64 32900 5
View Market Depth
Last trade - 16.10pm 27/06/2024 (20 minute delay) ?
WHC (ASX) Chart
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.