Hi - i can get this working in various ways but i can't seem to nail my solution in one formula. trying to an if between formula that if the value of D5 is between -1 and 1 the result is 0.01... BUT
if D5 is a negative number and between -1 and 1 the answer will be -0.01
if D5 is a positive number and between -1 and 1 the answer will be 0.01
the answer is in a column that calculates cost which is why if D is a negative number i need the cost to also be negative result.
TIA
if D5 is a negative number and between -1 and 1 the answer will be -0.01
if D5 is a positive number and between -1 and 1 the answer will be 0.01
the answer is in a column that calculates cost which is why if D is a negative number i need the cost to also be negative result.
TIA