Sửa lỗi công thức excel "the formula you typed contains an error"

So I"m currently writing this formula in Microsoft Excel lớn automate filling in one cell

=IF(M4=25500;"-5460";"0")))

Basically, what it does is checking whether cell M4 contains less than or equal to lớn 3,0 value. If so, write "5460" in the cell. And also it checks whether cell I4 plus K4 more than or equals lớn 25500 then if so write minus 5460 (-5460).Bạn đã xem: The formula you typed contains an error

But an error saying "The formula you typed contains an error" occurs. I"m not quite sure which part is wrong. I"m newbie in if-nested excel formula. Anyone knows?

Thanks in advance!

excel excel-formula excel-2010 ms-office formula share Improve this question Follow asked Dec 22 "17 at 8:19

zdrasvutyezdrasvutye 111 silver badge44 bronze badges địa chỉ cửa hàng a phản hồi |

2 Answers 2

Active Oldest Votes 1 This if statements should replace the fail values, và the separation should be consistent. Try this:

=IF(M4=25500,"-5460","0")))Or if your system is mix up for semicolon separation:

=IF(M4=25500;"-5460";"0"))) mô tả Improve this answer Follow edited Dec 22 "17 at 8:31 answered Dec 22 "17 at 8:23

Richard VoddenRichard Vodden 22533 silver badges88 bronze badges 2 địa chỉ cửa hàng a comment | 0 Remember khổng lồ use only three parameters in your if, In your example, you are using four. The "0" is redundant và makes the formula invalid.

Bạn đang xem: Sửa lỗi công thức excel "the formula you typed contains an error"

The value khổng lồ evaluateThe value when the evaluation is trueThe value when the evaluation is false

=IF(M4=25500; -5460; 0)))

giới thiệu Improve this answer Follow answered Dec 22 "17 at 8:31

SurfManSurfMan 1,26288 silver badges1616 bronze badges 2 add a phản hồi |

Your Answer

Thanks for contributing an answer to lớn Stack Overflow!

Please be sure khổng lồ answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.Making statements based on opinion; back them up with references or personal experience.

Xem thêm: Kiểm Tra Tài Khoản Khuyến Mãi Mobifone Còn Lại Và Hạn Dùng, Cách Kiểm Tra Tài Khoản Khuyến Mãi Km99T Mobifone

To learn more, see our tips on writing great answers.

Draft savedDraft discarded

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using thư điện tử and Password Submit

Post as a guest

Name thư điện tử Required, but never shown

Post as a guest

Name e-mail

Required, but never shown

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to lớn our terms of service, privacy policy & cookie policy

Not the answer you're looking for? Browse other questions tagged excel excel-formula excel-2010 ms-office formula or ask your own question.

The Overflow Blog Upcoming Events Featured on Meta Related 2028 How vị I create an Excel (.XLS và .XLSX) file in C# without installing Microsoft Office? 233 Return empty cell from formula in Excel 685 How to lớn use Regular Expressions (Regex) in Microsoft Excel both in-cell và loops 1 Excel Chart Referencing Cell With Formula 0 Excel - IF Formula with a FIND 0 Excel formula to kiểm tra if previous column has N/A 1 Excel Formula that generates a #REF! error 0 How khổng lồ develop formula based on contents of two cells 0 How to I pass a formula to lớn an excel file in vba Hot Network Questions more hot questions

Question feed Subscribe lớn RSS Question feed to subscribe to this RSS feed, copy & paste this URL into your RSS reader.

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device & disclose information in accordance with our Cookie Policy.