Help with formula

[Peter1973]

Can anyone help me I am using the formula

=(T6/100)*$C$32 which is fine however if T6 is greater than 0 i would like the formula to give me a zero and when the formula gives me a negative answer ie -4 I want it to remove the minus sign and represent it as a postive number.

Any help greatly appreciated

 

[Aladin Akyurek]

=ABS(MIN(0,(T6/100)*$C$32))

 

[Peter1973]

Thanks would never have got that.

 

[Scott Huish]

Since you never return a value greater than 0, I think you can eliminate the ABS function call

=-MIN(0,(T6/100)*$C$32)