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...
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. 😊😊
