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
=(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