WHC 3.84% $8.92 whitehaven coal limited

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

  1. 6,021 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
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.