need help with formula

Copper Contributor

hello I'm trying to get this to work but no luck, any help would be greatly appreciated

2 Replies

@edcarron 

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)

thank you very much, it works perfectly. much appreciated