I'm working on an Excel tax sheet that contains numerous if statements to account for the various tax rates. Currently, I cannot get the last if statement to work no matter how much I modify it. I'll include some images so I can better illustrate it. K26 contains the If statement by itself. It appears to be like this:  The highlighted cells are changed to make this function.

The problem is that it works up to 20 000 000 NOK, but a number higher than that in AM24 does not show in K26. I am pretty convinced it's a problem with the second part of the statement, but I can't get it to work no matter how I approach the function.

I have tried adding values as numbers in the IF statement.  I have also tried changing the numbers with the corresponding Cell values, but nothing seems to work, I am pretty sure it's an easy solution, but I can't see it clearly.

Mar 20 in Others 176 views

## 1 answer to this question.

Use vlookup() as that is much easier to control and edit as the rates and thresholds change:

`VLOOKUP(E3,\$B\$4:\$C\$7,2,1)`
• 63,180 points

## 'Microsoft.Office.Interop.Excel.Range' does not contain a definition for 'get_Default'

You are using C# version 4, the ...READ MORE

## Excel does not show hidden sheet but if i unzip it, then there are 2 worksheets

I now know that an Excel worksheet ...READ MORE

## Is Peterson’s Algorithm a good solution for Critical Section problem? If yes, then why? If no, then why?

Peterson’s solution provides a good algorithmic description ...READ MORE

## Flutter Error: MediaQuery.of() called with a context that does not contain a MediaQuery.

Hi@akhtar, You need a MaterialApp or a WidgetsApp around your widget. They ...READ MORE

## Excel Formula - if values in columns all contain X then return

You can use the AND function: = IF(AND(A3="OK";B3="OK";C3="OK");"everything ...READ MORE

## (Excel) If cell is greater than <condition> then minus <number>

The IF function to calculate B5 (amount ...READ MORE

## IfError with else, does this function exist in Excel?

Next to IFERROR(), there also is the ISERROR() function, which ...READ MORE