Forum Discussion
SeanC1970
Nov 20, 2018Copper Contributor
Need help with formula
I'm sure this will be a simple one for most, but since I'm no expert with Excel I'm reaching out. I need to calculate hours for overtime once a condition has been met. The condition is 40.
If cell data is greater than 40, display value
Cell data = 42
Output would = 2
After this, I have a more difficult one I'll need help with as well.
Thanks all !
- Lorenzo KimBronze Contributorif A1 = 42 and output cell is in B1 , formula in B1 = if(A1>40,A1-40,"")
HTH