0 votes

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, 2023 in Others 425 views

## 1 answer to this question.

0 votes

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)`
answered Mar 20, 2023 by
• 63,720 points

0 votes
1 answer

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

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

0 votes
1 answer

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

0 votes
2 answers

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

0 votes
1 answer

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

0 votes
1 answer

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

0 votes
1 answer

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

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

0 votes
1 answer

## Multiple IF statements in Excel not working

When you add an IF statement to a formula ...READ MORE

0 votes
1 answer

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

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

0 votes
1 answer

## A button in excel sheet does not work for the first time

When you press the Display button, the ...READ MORE

0 votes
1 answer

## JavaScript API does not work for Excel 2013?

Each method in the Office.js APIs is ...READ MORE