Originally Posted by NeverBX
dude you are awesome but I dont get the formula though. it works though. can you explain it to me?
=IF(B6>=40.01,B6-$B$1,"0")
This is saying:
If the value in B6 is greater than 40.01, then the resulting value in the new cell will be the value of B6 minus the value of B1. If not, it will = 0.