Forum Discussion

moanawatt's avatar
moanawatt
Copper Contributor
Sep 28, 2022
Solved

MS Excel is say "You have entered too many arguments." How can I solve this problem?

👋ðŸŧ āļŠāļ§āļąāļŠāļ”āļĩāļœāļđāđ‰āļŠāļ™āļąāļšāļŠāļ™āļļāļ™ āļ‰āļąāļ™āđ„āļĄāđˆāļŠāļēāļĄāļēāļĢāļ–āđƒāļŠāđˆāļŠāļđāļ•āļĢāđƒāļ™ MS Excel āđ„āļ”āđ‰ āđ€āļ™āļ·āđˆāļ­āļ‡āļˆāļēāļ MS Excel āļĄāļĩāļ‚āđ‰āļ­āļ„āļ§āļēāļĄāļ§āđˆāļē "āļ„āļļāļ“āđ„āļ”āđ‰āļ›āđ‰āļ­āļ™āļ­āļēāļĢāđŒāļāļīāļ§āđ€āļĄāļ™āļ•āđŒāļĄāļēāļāđ€āļāļīāļ™āđ„āļ›āđāļĨāđ‰āļ§"   āļŠāļđāļ•āļĢāļ‚āļ­āļ‡āļ‰āļąāļ™āļ„āļ·āļ­ =IF(V12>79,"4",IF(V12>74,"3.5",IF(V12>69,"3",IF(V12...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 28, 2022

    moanawatt Perhaps like this?

    =IF(V12>79,"4",IF(V12>74,"3.5",IF(V12>69,"3",IF(V12>64,"2.5",IF(V12>59,"2",IF(V12>54,"1.5",IF(V12>49,"1",IF(V12>45,"āļĢ","0"))))))))

     

    And are you sure you want the returns the numbers 0 to 4 as texts? If not, you should remove the quotation marks.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Sep 28, 2022

moanawatt Perhaps like this?

=IF(V12>79,"4",IF(V12>74,"3.5",IF(V12>69,"3",IF(V12>64,"2.5",IF(V12>59,"2",IF(V12>54,"1.5",IF(V12>49,"1",IF(V12>45,"āļĢ","0"))))))))

 

And are you sure you want the returns the numbers 0 to 4 as texts? If not, you should remove the quotation marks.

moanawatt's avatar
moanawatt
Copper Contributor
Sep 29, 2022
Many thanks for your assistance. 😊😊

Resources