Forum Discussion
formula with many conditions using greater than less than and equal to in spreadsheet
I am having an error with a formula that has result conditions with multiple arguments. In the equation I am trying establish the following: if column "B" is 1 but less than 5 result in Column "C" i...
Try this one. A bit different from the traditional nested IF formula:
=(AND(B6>1,B6<5)*2+AND(B6>=5,B6<10)*3+AND(B6>=10,B6<25)*4+(B6>=25)*5)
thank you, that worked; added equal sign before the "1" also to include singular quantity. thank you again
