Formula comes up as #N/A after data is entered. Yet before that data is entered, it works normally.

I have a formula that is corrct in syntax but still comes up with an #N/A value.

To ensure the best support experience, please stay active in this chat window and respond within 2-3 minutes. Switching apps or changing focus to another window while working with us may get you disconnected from the chat session.

For your security, please avoid providing sensitive information such as Product keys, Passwords and Credit Card information on this chat box.

Yes

Yes. Look at the Patterns tab cell J21.

The formula is correct. However when I enter in values for AF4 - AF21 on the first tab, the formula comes up with a result of N/A.

Before we continue further, may I ask for your email address and phone number for verification purposes?

email address removed for privacy reasons 512-619-4536

Is this the first time that you have contacted Microsoft about this issue?

Yup. I think this time I found a bug.

Ok.

365

Yes.

I am not a community poster. That's why when I really get stuck, I rely on you al to do the research on that.

Also, if you eleminate the data from that last column, it works perfectly. but if that column is populated, it goes wonky.

Since you have an active Microsoft 365 subscription, you're entitled to free Office support.

Whatever. I've gotten help like this before without having to turn to a community.

Would it be okay if I connect to your computer for me to better check the issue? We would use Quick Assist app, so I could remotely access your device.

Ok.

Please press CRTL + Windows key + Q simultaneously to open Quick Assist app.

It's open.

Okay. Watch closely.

As you can see, it works normally.

**bleep**. I said watch closely.

Normal flow here.

The highlighted cell is calculating correctly. because the cell it's referencing is working normally.

=IFS(AND(E64>=MIN(0.9),E64<=MAX(0.999)),"A",AND(E64>=MIN(0.8),E64<=MAX(0.899)),"B",AND(E64>=MIN(0.7),E64<=MAX(0.799)),"C",AND(E64>=MIN(0.6),E64<=MAX(0.699)),"D",AND(E64>=MIN(0.001),E64<=MAX(0.599)),"F",E64="","N/A",E64=1,"A+")

Now. I'm going to populate that last column.

Okay. That last column is populated.

There's yur error. Even though the cell it's referencing is working normally. Get it?

Sure.

What do you mean? I showed you the data flow so to speak.

That cell is based on the calculation of #64. Right on that same sheet.

Can I try something right quick before you really get stupid here?

Nope. I populated the data into the template. Same result. You have a bug. The formulas are correct.

That's interesting. An earlier spreadsheet has normal functionality. The question is, if I never made any changes to references or formulas, why the strange behavior?

Yeah. There's a deeper root cause hhere.

Yes.

But did you see I pulled earlier workbooks with 31 days recorded and it worked?

Hmmm.

The problem is, I haven't really copywrited these workbooks. I really don't want my ideas stolen here.

Yeah, I have a problem with that explanation thogh in that how would additional data change that formula or the cell characteristics, especially when the data is being referenced origonally from another page.

And why would it be normal in a previous workbook, but corrupted in the master which wasn't changed at all?

So this must have happened betwen July and now. When I do a new monthly spreadsheet, I open the master as my template and save it as the current month, then populate it day by day.

Okay.

I will now end the remote session so you can have your privacy back.

Thank you.

Thank you.

Since I was able to provide you enough information that you need for today, can we close this case?

For now, I suppose.

Thank you for contacting Microsoft Support. This has been Joko. Have a great day and keep safe.

Sure.