WHC 0.34% $8.97 whitehaven coal limited

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

  1. 6,023 Posts.
    lightbulb Created with Sketch. 986
    =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
$8.97
Change
0.030(0.34%)
Mkt cap ! $7.504B
Open High Low Value Volume
$8.90 $9.00 $8.87 $32.72M 3.654M

Buyers (Bids)

No. Vol. Price($)
1 7424 $8.97
 

Sellers (Offers)

Price($) Vol. No.
$8.98 38344 7
View Market Depth
Last trade - 16.10pm 05/07/2024 (20 minute delay) ?
WHC (ASX) Chart
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.