# 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?

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 |

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.

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

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

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

But avoid

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

### Post as a guest

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

### Post as a guest

Name e-mail

Required, but never shown