Nov 09 2021 04:20 AM
hello I'm trying to get this to work but no luck, any help would be greatly appreciated
Nov 09 2021 04:48 AM
Try
=B2*C2*D10-IF(B2*C2*D10<100,10,30)
This will become negative if B2*C2*D10 is less than 10. To prevent this, use
=MAX(B2*C2*D10-IF(B2*C2*D10<100,10,30),0)
Nov 09 2021 05:19 AM