# Thread: Simple Fx using addition leads to #VALUE result and I don't know why... Thanks:  3 Post #5340556 (1)Post #5340566 (1)Post #5340578 (1) Likes:  3 Post #5340556 (1)Post #5340566 (1)Post #5340578 (1)

1. ## Simple Fx using addition leads to #VALUE result and I don't know why...

(Excel for Mac 2013) I'm sure there is a simple solution:

I am adding up every other cell in a horizontal row (A1+C1+E1+G1+I1) and totaling the numbers in these cells in cell K1.

In cell C1, there is an =IF(AND fx that results an integer, but when I add cells A1+C1+E1+G1+I1, the fx result in C1 is creating a "#VALUE" response in cell K1 rather than a sum of the numbers in the 5 aforementioned cells.

I've tried changing the format of the cells to 'General' and 'Number'...etc. but nothing is working.

Any ideas?

2. ## Re: Simple Fx using addition leads to #VALUE result and I don't know why...

What is the formula in C1?

3. ## Re: Simple Fx using addition leads to #VALUE result and I don't know why...

=if(and(q8<-2.88,q8>-6.9,r8<16.3,r8>-10,d8<-5.5,d8>-11),1,"")

4. ## Re: Simple Fx using addition leads to #VALUE result and I don't know why...

Change that last "" to 0

5. ## Re: Simple Fx using addition leads to #VALUE result and I don't know why...

Just tried it. Unfortunately, it didn't work.

Any other ideas?

6. ## Re: Simple Fx using addition leads to #VALUE result and I don't know why...

Originally Posted by brose99
Just tried it. Unfortunately, it didn't work.

Any other ideas?
Are the numbers in cells D8 and/or Q8 and/or R8 perhaps entered as text values?

7. ## Re: Simple Fx using addition leads to #VALUE result and I don't know why...

NAILED IT! Thanks petertenthije and Toadstool!!

Solved