IF statement for a tax sheet does not work

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: enter image description here The highlighted cells are changed to make this function.

enter image description here

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. enter image description here 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 by Kithuzzz
• 38,010 points
318 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:

enter image description here

VLOOKUP(E3,$B$4:$C$7,2,1)
answered Mar 20, 2023 by narikkadan
• 63,420 points

Related Questions In Others

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

answered Oct 16, 2022 in Others by narikkadan
• 63,420 points
1,685 views
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

answered Nov 12, 2022 in Others by narikkadan
• 63,420 points
344 views
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

answered Jul 6, 2020 in Others by Gitika
• 65,910 points
1,918 views
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

answered Aug 27, 2020 in Others by MD
• 95,440 points
4,816 views
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

answered Nov 4, 2022 in Others by narikkadan
• 63,420 points
1,129 views
0 votes
1 answer

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

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

answered Nov 7, 2022 in Others by narikkadan
• 63,420 points
749 views
0 votes
1 answer

Multiple IF statements in Excel not working

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

answered Nov 12, 2022 in Mobile Development by narikkadan
• 63,420 points
238 views
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

answered Dec 23, 2022 in Others by narikkadan
• 63,420 points
290 views
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

answered Mar 30, 2023 in Others by narikkadan
• 63,420 points
222 views
0 votes
1 answer

JavaScript API does not work for Excel 2013?

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

answered Sep 26, 2022 in Others by narikkadan
• 63,420 points
380 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP