Forum Discussion
Solved
Formule Excel
I'm constantly searching, but can't find. I need a formula. For example. Someone travels 49 kilometers. The formula should not count up to 40 kilometers. So just the 9. (49-40) 9 kilometers to be pai...
=MAX(0,A1-40)
You can try this formula if you want to return 0 if 21 is in cell A1.
=IF(A1>=40,A1-40,"")
This formula returns a blank cell if 21 is in cell A1.
=MAX(0,A1-40)
You can try this formula if you want to return 0 if 21 is in cell A1.
=IF(A1>=40,A1-40,"")
This formula returns a blank cell if 21 is in cell A1.
This is him. Thank you very much OliverScheurich!