Help with a formula returning the word "FALSE" Please

[Get_Involved]

Step 1

When I type any number 6 through 9 MPG in Cell K9, this formula works.

(This formula is placed in Cell L10

 IF(K9=6,((B8*0.01)),IF(K9=6.5,((B8*0.02)),IF(K9=7,((B8*0.03)),IF(K9=7.5,((B8*0.04)),IF(K9=8,((B8*0.05)),IF(K9=8.5,((B8*0.06)),IF(K9=9,((B8*0.07)))))))))

)

I have a tab named Fuel Report that has the MPG in Cell U39.

Step 2

(When I put this formula in cell K9

 =IFERROR(1/(1/IF('Fuel Report'!U39,(('Fuel Report'!U39)))),"")[/ CODE]

It returns the numbers 6 Through 9 based on gallons bought and miles ran, in cell K9.)

However now it is returning the word “FALSE” in Cell L10

Can anyone explain to  me how I am writing this formula wrong please?

 

[GraH]

Hi,

In both cases in your IF statements there is a scenario where "FALSE" is a possible answer.
= IF(K9=6,((B8*0.01)),IF(K9=6.5,((B8*0.02)),IF(K9=7,((B8*0.03)),IF(K9=7.5,((B8*0.04)),IF(K9=8,((B8*0.05)),IF(K9=8.5,((B8*0.06)),IF(K9=9,((B8*0.07))))))))) , the red part has no FALSE argument.
= IFERROR(1/(1/IF('Fuel Report'!U39,(('Fuel Report'!U39)))),"") , same as above no FALSE argument.

So when the IF formula evaluates a scenario as FALSE it will return FALSE when that argument is missing.

 

[Get_Involved]

GraH Thanks for your response.
I understand what you are saying. Although I am not sure how to rewrite the formula to make it work as intended.

 

[GraH]

That long nested IF for sure seems a candidate for a VLOOKUP.

 

[Get_Involved]

Thanks I thought that would work,tried that already, I will keep working on it thanks because I know you are rite.

 

[Get_Involved]

I have tried all the VLOOKUP arrangements I know, still returning the word “FALSE”

 

[Get_Involved]

How do I write the formula, or Formulas above to remove the scenario of "FALSE" as a possible answer?

 

[Get_Involved]

Reworked the question

I have 2 tabs

One is tab named “Fuel Report”

The second is named “Incentive Pay”

_______________________________________________________________

Step 1

When I type any number 6 through 9 MPG in Cell K9, of “Incentive Pay” this formula works.

(This formula below is placed in Cell L10

 IF(K9=6,((B8*0.01)),IF(K9=6.5,((B8*0.02)),IF(K9=7,((B8*0.03)),IF(K9=7.5,((B8*0.04)),IF(K9=8,((B8*0.05)),IF(K9=8.5,((B8*0.06)),IF(K9=9,((B8*0.07)))))))))

It works perfect.

________________________________________________________________



I have a tab named Fuel Report that has the MPG in Cell U39.

Step 2

(When I put this formula in cell K9

 =IFERROR(1/(1/IF('Fuel Report'!U39,(('Fuel Report'!U39)))),"")

It returns the numbers expected, 6,6.5,7,7.5,8,8.5,9 in cell K9.)

However now this Code

IF(K9=6,((B8*0.01)),IF(K9=6.5,((B8*0.02)),IF(K9=7,((B8*0.03)),IF(K9=7.5,((B8*0.04)),IF(K9=8,((B8*0.05)),IF(K9=8.5,((B8*0.06)),IF(K9=9,((B8*0.07)))))))))

,
is returning the word “FALSE” in Cell L10

Can anyone give an example of how I should be writing this formula please?

Thanks in Advance

 

[GraH]

At first glance I do not see something wrong with the overall syntax, except this looks suspicious
= IF(K9=6,((B8*0.01)),IF(K9=6.5,((B8*0.02)),IF(K9=7,((B8*0.03)),IF(K9=7.5,((B8*0.04)),IF(K9=8,((B8*0.05)),IF(K9=8.5,((B8*0.06)),IF(K9=9,((B8*0.07)))))))))

those "8"s should be "9"s?