If formula

[Babasaheb Dabade]

Dear,

My file is showing two values that is -15 and 15.

please prepare formula such that,
if value is in between -1 to -1000 , it should become -1000
and
if value is in between 0 to 1000 , it should become 1000

Thanks in advance

Babasaheb Dabade

 

[NARAYANK991]

Hi ,

Your question needs to be phrased more explicitly.

Are the only possible values 1000 and -1000 ?

Are the inputs all integer values , or will there be values such as -0.5 ? If so , for a value between 0 and -1 what is the output supposed to be ?

What about when the input value is beyond either 1000 or -1000 ?

If all the inputs will be integers , then one way is :

=SIGN(inputvalue+0.1) * 1000

If the input value is positive , the output will be 1000 , if the input value is negative , the output will be -1000.

Narayan