Forum Discussion

MarleneCunliff's avatar
MarleneCunliff
Copper Contributor
Jun 24, 2021
Solved

Nested Formula

Good day I need help pleas   IF(M4>80,"7",(M4>70,"6",(M4>60,"5")))
Formulas and Functions
  • JKPieterse's avatar
    JKPieterse
    Jun 24, 2021

    Place the numbers in a two-column table, similar to this:

      A  B
1 60 5
2 70 6
3 80 7



    And use a formula like this:
    =VLOOKUP(M4,$A$1:$B$3,2,TRUE)

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 24, 2021

MarleneCunliff As a variant, and if you insist on using nested IF's, perhaps this is what you tried to achieve:

=IF(M4>80,"7",IF(M4>70,"6",IF(M4>60,"5","x")))

where "x" will be returned for any value in M4 less than or equal to 60. Remove the ,"x" part and it will return FALSE in such case.

Resources