Jun 01 2022 01:06 AM
Hi, I would like to know how can I command the result on a cell to be between certain range of values (0 to 1). I already have a formula on the cell (with nested if), I just want if the result is below zero, to give zero, and if its above one, to give one.
Jun 01 2022 01:13 AM
If the value is in A1...
=IF(A1>1,"1",IF(A1<0,"0",A1))
Hope I could help you with these information.
I know I don't know anything (Socrates)
Jun 01 2022 01:37 AM
Jun 01 2022 01:34 AM
Solution