# Mismatch of Logical Test and Cell Answer

#### Ed Song

##### Board Regular
My formula in the cell is =IF(C190>=\$B\$9,\$F\$9*(D52-\$B\$9), \$F\$5*(D52-\$D\$7))

The Cell output is 8.21 - Which is incorrect.

The Logical Test when clicking on function is

Logical Test: C190>=\$B\$9 TRUE

Value if True \$F\$9*(D52-\$B\$9)= 86.2

Value if False \$F\$5*(D52-\$D\$7)= 8.21

I've calculated the formula by hand, and the answer is 86.2.

What is causing the mismatch of the cell output and the logical test? Is my file corrupted? What do I do if my file is corrupted?

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Welcome to the forum

Sounds strange . Is your workbook calculation mode set to automatic? except the cell isn't showing the updated value

Try pressing F9 to recalculate the workbook and see what the result is

Yes, the workbook calculation mode is set to automatic. However, because I had a simultaneous equation and couldn't find a way around it, I set the iteration mode on. I've noticed some instability in the workbook ever since I set the mode on. No change when I press F9.

Last edited:
What are the values of C190, \$B\$9,\$F\$9, D52, and \$F\$5 and \$D\$7 that gives that wrong result.

C190=160, \$B\$9=160, \$F\$9=.5, D52=332.4, \$F\$5=.025, and \$D\$7=4

I entered your values and copy pasted the formula and got 86.2.
I suspect that your error is caused by C190 or B9 as text instead of numbers.

Actually, the answer should be 172.4. So my excel program is not even calculating simple arithmetic correctly. Oh I forgot to multiply by .5

Last edited:
I think you are correct. I found some of my parameters set without an = sign in front of it. I'm fixing the problem now. In my latest attempt however, many of the cells got the ref output. Thanks for your help.

Unfortunately, as far as I can tell, everything seems to be in math mode and I still have the same problem.

Looks like I solved the problem, but don't know why. Apparently, there was an error in what appeared to be an unrelated cell. However, when I corrected for the error, the mismatch problem was solved. I believe that the workbook being on iterative mode may have something to do with the instability of the program. My program is becoming quite big and complicated.

Replies
3
Views
139
Replies
4
Views
226
Replies
18
Views
445
Replies
1
Views
622
Replies
6
Views
1K

1,221,090
Messages
6,157,880
Members
451,447
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back