I have an if function statement that returns multiple possible results in column I from a formula in column H. The formula works unless the result in column H is a negative number, e.g., -4, then I get a 0 in Column I instead of the expected 5. How can I get my If statement to calculate the negative number?
Column H
=IF(H8="N/A",0,IF(H8="Perpetual",0,IF(H8<=1,5,IF(H8=2,3,IF(H8>=3,0,"")))))
Column I
=IF(H8="N/A",0,IF(H8="Unknown",5,IF(H8<=1,5,IF(H8=2,3,IF(H8>=3,0,"")))))
Bookmarks