Forum Discussion
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>64,"2.5",IF(V12>59,"2",IF(V12>54,"1.5",IF(V12>49,"1","0",IF(V12>45,"āļĢ)))))
(āļāļĄāđāļāđāļŠāļđāļāļĢ IF)
āļŦāļĢāļ·āļāđāļāđāļāļāļēāļĢāļēāļāļāļ·āļ
>79 = 4
>74 = 3.5
>69 = 3
>64 = 2.5
>59 = 2
>54 = 1.5
>49 = 1
>45 = āļĢ
<45 = 0
āļ āļēāļāļāđāļēāļĒāđāļāļĩāđāļĒāļ§āļāļąāļāļāļąāļāļŦāļēāļāļāļāļāļąāļ :framed_picture:
āđāļāļ āļēāļāļāļāļāļāļąāļ MS Excel āļāļ·āļāļāļđāļāļ§āđāļē"āļāļļāļāđāļāđāļāđāļāļāļāļēāļĢāđāļāļīāļ§āđāļĄāļāļāđāļĄāļēāļāđāļāļīāļāđāļ." āđāļ ENG Lang
āļāļąāļāļāđāļāļāļāļēāļĢāđāļŦāđāļāļđāđāļŠāļāļąāļāļŠāļāļļāļāļāđāļ§āļĒāđāļāđāļāļąāļāļŦāļēāļŦāļĢāļ·āļāļāļīāļāļŠāļđāļāļĢāđāļŦāļĄāđ
āļāļāļāļāļļāļāļŠāđāļēāļŦāļĢāļąāļāļāļļāļāļŠāļīāđāļāļāļĩāđāļāļļāļāđāļāđāļāđāļē ð
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 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.
- Many thanks for your assistance. ðð
