bdev,

Welcome to the forum!
If the total revenue is in cell A1:
=A1-MAX(174000,A1*0.15)