Hi. I am trying to get multiple if and statements to work. Basically, if the number in cell g falls between 1000-1300 return -150, if between 1300-1800 return -200. The first condition worked and returned -150 but once i added the next if statement it still returns -150. Can anyone help please?
Hello @sonia6494 and welcome to the Make Community!
Your comparison operators are being treated as text so they’re essentially always true, therefore always returning -150. Try surrounding the >= with double angle brackets, like this {{>=}} and they should change to actual operators and turn green like the and operators..
Also, what needs to happen if G is less than 1000 or greater than 1800?
3 Likes
Thank you! That makes sense and it worked. I have added the other conditions under 1000 and over 1800 and it all works like it should.
1 Like