Error in If statements

Warren99 · #1 05-29-2016, 01:51 AM

I tried this but it came up with a #NAME? error which would indicate I do not have Excel 2016. Thank you for your help. The previous solution worked so all is well.

Pecoflyer · #2 05-29-2016, 02:01 AM

Quote:

Originally Posted by Warren99

I tried this but it came up with a #NAME? error which would indicate I do not have Excel 2016.

OTH you indicate in your data that you use Office2016??

The 0 is the result if J18 is not equal to 76 nor 89

Warren99 · #3 05-29-2016, 04:10 AM

I do have but there must be some other glitch. I have sorted out the problem but thanks for your help.

Kevin@Radstock · #4 05-29-2016, 01:59 PM

Quote:

Originally Posted by Warren99

I tried this but it came up with a #NAME? error which would indicate I do not have Excel 2016. Thank you for your help. The previous solution worked so all is well.

Then correct the version of office you are using and not misleading people.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with if then statements	brent chadwick	Word VBA	35	07-25-2015 02:41 PM
Using IF statements	stuwoolf	Excel	2	01-10-2015 01:58 PM
count if statements	Alaska1	Excel	1	05-14-2014 08:21 AM
Multiple If statements	bremen22	Excel	2	10-15-2013 06:37 AM
IF statements that shifts to right.	kent	Excel	0	01-19-2006 02:23 PM