absolute value

[apgmin]

Cell A1 has the initial rate ( a number with 2 decimals places like say 2.38 )
Cell B1 also has the initial rate ( a number with 2 decimals places like say 2.38 )
Cell C1 also has the initial rate ( a number with 2 decimals places like say 2.38 )
Now cell D1 is (A1-B1)xC1

I want the answer to be zero if the result of (A1-B1)xC1 is A positive number and
IF (A1-B1)xC1 is a negative number I want it to display without the minus sign ie as a positive number

 

[JackDanIce]

In D1, try:

=ABS(MIN(C1*(A1-B1),0))

 

[Special-K99]

What do you want if (A1-B1)*C1 is zero (since zero is neither positive nor negative).

IF((A1-B1)*C1<0,ABS((A1-B1)*C1),0)

 

[JackDanIce]

IF A1:C1 all equal 0 and C1*(A1-B1)=0, ABS(MIN(C1*(A1-B1),0)) also returns 0
Similarly if A1 = 5, B1 = 5 and C1 = -5, ABS(MIN(C1*(A1-B1),0)) returns 0

My guess is ABS returns a number and since 0 is the ceiling provided, whether answer of 0 is positive or negative becomes moot?