creating a formula that allow greater than number be determined

T

Terry

I am trying to create a formula that allow me to calculate number in a cell
only when the number excess 120,000 and only the numbers above that number.
Any number below 120,000 will should up as zero.

terry
 
Top