=IF(E7>=1,1,E7(E7<0,0,E7))
So on the back end of this I want the cell to fill 0 if e7 is a negative number. what am I doing wrong?
The goal is if cell e7 comes back between 0 and 1 I want it to display the number. If it comes back greater that 1 I want it to display as 1, if it comes back as a negative number I want it to display 0. HELP!
Bookmarks