I received a formula earlier today:

=IF(COUNTIF($G$2:$G$31,$G2)=1,$C2,IF(COUNTIFS($G$2:$G$31,$G2,$C$2:$C$31,">"&$C2)>0,"-",$C2))

Currently this formula checks if I have a duplicate date, then shows the highest value of the adjacent columns.
Whichever is the lowest number out of the duplicates shows as "-" (0)

Would there be a way to multiply the lowest figure(s) by 25% instead of reverting the field to 0