If, Then Values
 

I am trying to find a formula that will return a value in another cell if the
number is greater than the selected cell. Example:

cell A1 is 100
cell A2 is 150

I want the difference of 50 to be returned in cell A3 only if its a greater
number.

Hope it makes sence.

Thanks
CMS

If, Then Values
 

So, if I understand, you want A3 to be the difference of A2 and A1 only if A2
is greater than A1? If so, use this formula in A3:

=IF(A2A1,A2-A1,"")

Cell A3 will remain blank if A1 is greater than or equal to A2.

HTH,
Elkar


"bassplayerbg" wrote:

I am trying to find a formula that will return a value in another cell if the
number is greater than the selected cell. Example:

cell A1 is 100
cell A2 is 150

I want the difference of 50 to be returned in cell A3 only if its a greater
number.

Hope it makes sence.

Thanks
CMS

If, Then Values
 

One way:

=IF(A2 A1, A2 - A1, "")

In article ,
bassplayerbg wrote:

I am trying to find a formula that will return a value in another cell if the
number is greater than the selected cell. Example:

cell A1 is 100
cell A2 is 150

I want the difference of 50 to be returned in cell A3 only if its a greater
number.

Hope it makes sence.

Thanks
CMS

If, Then Values
 

=MAX(A2-A1,0)


"bassplayerbg" wrote:

I am trying to find a formula that will return a value in another cell if the
number is greater than the selected cell. Example:

cell A1 is 100
cell A2 is 150

I want the difference of 50 to be returned in cell A3 only if its a greater
number.

Hope it makes sence.

Thanks
CMS