If function formula, may I ask where my formula is wrong?

There are two errors in your formula:

1.k4-1600=500 This case is missing.

2.The 500 correct formula is as follows:

if(k4-1600<=500,(k4-1600)*5%,if(and(500

Help you modify the original formula a little, it should meet your above requirements, and your minimum standard should also be set, otherwise negative numbers will come out.

if(k4<=1600,0,if(k4-1600<=500,(k4-1600)*5%,if(k4-1600<=2000,(k4-1600)*10%-25,if(k4-1600<=5000,(k4-1600)*15%-125,(k4-1600)*20%))

Incomplete. As the title suggests, make a reference:

if(k4<2100,0,if(k4<3600,(k4-1600)*5%,if(k4<6600,(k4-1600)*10%,k4*15%))

Summary. If you are using Excel's if function, the result is displayed incorrectly when there are no errors in the formula, there may be several reasons: The parameters of the if function are not formatted correctly.

The if function needs to have three parameters, which are the logical test, the result when the value is true, and the result when the value is false. If the parameters in parentheses are not formatted correctly, the result will be incorrect. The judgment condition of the logic test is incorrect.

When using the if function to make a logical judgment, you need to ensure that the judgment conditions are correct. For example, if you use the ">" symbol for comparison, but you should actually use ".

If you are using Excel's if function, the result is displayed incorrectly when there are no errors in the formula, there may be several reasons: The parameters of the if function family are incorrectly formatted. The if function needs to have three parameters, which are the logical test, the result when the value is true, and the result when the value is false.

If the parameters in parentheses are not formatted correctly, the result will be incorrect. The judgment condition of the logic test is incorrect. When using the if function to make a logical judgment, you need to ensure that the judgment conditions are correct.

For example, if you use the ">" symbol for comparison, but you should actually use ".

There is a problem with the formula, which returns a numerical result, but it is not calculated according to the condition.

If the if function returns a numeric result, but not the search method for the condition, it may be because you used other formulas or functions in the "Value Returned on True" and "Changed Value Returned When Not True" that are calculated differently than you expect. Please check and confirm that the syntax and arguments of all formulas and functions you use are correct, and that they meet your expectations.

If you use the if function in Excel, but the formula shows the wrong answer without error, it may be caused by the following questions:1Wrong data type:

If you use the wrong data type in the if function, e.g. if you use a text value without touching the hole that is a numeric value, then the handful potato can cause the if function to be incorrect. Confirm that the correct type of data used in the formula is correct. 2.

Wrong cell formatting: If the cell is not formatted correctly, it can also lead to an error of the if function. Check whether the formula and cell formatting are consistent.

3.Wrong order of calculations: In the if function, if the order of calculations is not correct, it can also lead to wrong answers.

Confirm that the parts in the formula are calculated in the correct order. 4.Logical error:

The logic of the if function is important, and if the logic is wrong, it can also lead to the wrong answer. Confirm that the logic in the formula is correct. 5.

Wrong data source: If there is an error in the data source of the if function, it can also lead to an incorrect answer. Check whether the data source in the formula is correct.

If none of the above solutions can solve the problem, it is recommended to recheck whether the formula is correct and try other methods to solve the problem.

You can use the iferror function to catch and handle errors in formulas. iferror returns the value specified when the formula is calculated as an error. Otherwise, it will return the result of the formula.

The iferror function syntax has the following parameters:

value required. Check for incorrect parameters.

value if error is required. The value to be returned if the formula is calculated as an error. Evaluate the following error types:

#n/a、#value！、#ref！、#div/0！

#num！、#name？or null!.

Note. If the value or value if error is an empty cell, iferror treats it as an empty string value ("

If value is an array formula, iferror returns an array of results for each cell in the specified range in value. See the second example below.

The above refers to the microsoft-iferror function.

Summary. For example, =if(c2="yes",1,2) means if(c2 = yes, then 1, otherwise 2).

I'm really crazy, in the if function in excel, I am completely according to the requirements of the formula, why has it been an error, and I can't find the error in **?

You can send the picture below, I'll help you take a look, I helped someone solve the problem a few days ago.

I'm also learning functions and don't know why it's all wrong.

Need it urgently? I have some things that can be resolved later? Sorry for the order.

It's okay, you get busy first.

Uh-huh, thanks.

If you don't send it, I'll be cold when I find out.

Hello, can you complete the question? Feel free to take a picture of the formula you wrote.

The if statement can have two outcomes. The first result is that the comparison is true, and the second is that the comparison is false.

For example, =if(c2="yes",1,2) means if(c2 = yes, then 1, otherwise 2).

Except for double quotation marks can be Chinese, other must be English input method.

IfReplace "2500<=c2<7500".The interval representedUse "and(2500<=c2,c2<7500)" insteadcan solve the problem of returning "false" when using the if function.

In Excel 2007, the inscription formula is changed to the following public rock rough formula according to the above method, which can meet the requirements of the inscription of the jujube respect:=if(c2<2500,0,if(and(2500<=c2,c2<7500),10,if(and(7500<=c2,c2<12500),20,if(c2>12500,30,""Peishen)))).

The result of the formula is shown in the figure below:

Diagram of the results of the disclosure.

The d2 formula is better written like this:

if(c2<2500, 0, if(c2<7500, 10,if(c2<12500, 20,30 )

Because when judging C2 < 7500 for the second time, it is natural that C2 is not less than 2500, so there is no need to repeat the judgment. For example, it is necessary to assign people with different values of C2 to four floors, and the administrator of the flat floor only looks at whether the small calendar is empty at 2500, and the small one goes in, otherwise it goes upstairs; The administrator on the 1st floor only needs to take 7500 a ruler, and the small one is put in and the lead rock is otherwise upstairs, and the administrator on the 1st floor does not need to take a 2500 ruler to check, we have to trust the administrator of the flat floor. In the same way, the administrator on the 2nd floor only takes 12,500 rulers, and the small ones are put in, otherwise they go upstairs; The last third floor is the Huai Rotten Palace, which does not require an administrator, and those who come do not refuse because it trusts the administrators of the floors below.

Summary. Kiss! Hello, I'm glad to answer your <>

It may be an error caused by the wrong logical nesting of the if function. Please confirm:1

Check whether the syntax of the if function is correct. The syntax of the if function is: if(test, value if true, value if false).

Double-check that each parameter is typed and spelled correctly. 2.If function is nested correctly and parentheses are used correctly.

When nesting if functions, make sure to use parentheses correctly to ensure that excel calculates them in order. 3.The tilde ( ) escape character is used in the if function.

If there are double quotes or commas in one of the arguments of the if function, you need to use the tilde ( ) escape character to instruct excel to ignore the special meaning of the character. 4.The if function may have an error due to a case issue in the conditional test.

Make sure that the condition test for the if function is case-correct. 5.If function.

Please note that the first argument of the if function cannot contain a space, otherwise excel may produce wrong results. I hope I can help you<>

Do you have any other questions?

The if function formula is correct, but shows the wrong answer.

Kiss! Hello, I'm glad to answer for you<> it may be an error caused by the wrong logical nesting of the if function. Please confirm:

1.Check whether the syntax of the if function is correct. The syntax of the if function is:

if(test, value_if_true, value_if_false)。Double-check that each parameter is typed and spelled correctly. 2.

If function is nested correctly and parentheses are used correctly. When nesting if functions, make sure you use parentheses correctly to ensure that excel calculates them in order. 3.

The tilde ( ) escape character is used in the if function. If there are double quotes or commas in one of the arguments of the if function, you need to use the tilde ( ) escape character to instruct excel to ignore the special meaning of the character. 4.

The if function may have an error due to a case issue in the conditional test. Make sure that the condition test for the if function is case-correct. 5.

If function. Please note that the first argument of the if function cannot contain a space, otherwise excel may produce wrong results. I hope I can help you<>

Do you have any other questions?

Yes? What do you mean.