creating a formula that allow calculation only when number is > g.

T

Terry

I am trying to create a formula that allow me to calculate number in a cell
only when the number > (Greater than) or < (less than). I want to calculated
number only when the number excess 120,000 and only the numbers above 120,000
posted in a cell and any number below 120,000 will should up as zero.

Example: A1 cell has a numbe of 400,000

A2 cell will not calulcate unless A1 exceed 120,000 and the
number
exceeding 120,000 will be placed in A2 cell

terry
 
M

Mike Painter

Terry said:
I am trying to create a formula that allow me to calculate number in
a cell only when the number > (Greater than) or < (less than). I
want to calculated number only when the number excess 120,000 and
only the numbers above 120,000 posted in a cell and any number below
120,000 will should up as zero.

Example: A1 cell has a numbe of 400,000

A2 cell will not calulcate unless A1 exceed 120,000
and the number
exceeding 120,000 will be placed in A2 cell

terry
Click to expand...

iif(a1 > 120000, a1-120000,0)
 
T

Terry

Thanks Mike, the formula you sent was just what I needed.

I want to reverse the calcuation this time in another cell. I have try but
can't get it to work. I want a cell to now calculate numbers up to 120,000
but not to go pass 120,000.



Thanks Terry
 
Top