if-statementgoogle-sheetsmultiple-value

Multiple if conditions with 'more than' and 'less than' values


How do we write these statements and their respective values below using the IF() conditions?

I can't wrap my head around it after a couple of days of trials. Hope someone can clear this up for me.


Solution

  • @player0's answer is the answer I personally would use.

    If you must use IF-conditions, then the following might be useful:

    =IF(ISBETWEEN(A1;0;8);0;IF(ISBETWEEN(A1;9;18);10;IF(ISBETWEEN(A1;19;37);20;IF(ISBETWEEN(A1;38;52);30;IF(A1>=53;60;0)))))