Working with the "IF" function

[Michael of Hanson]

I am trying to create a registry for tracking mileage. I have two collums: One titled "Personal Miles" and the other titled "Business Miles". Both of these collums have the conditional "IF" function contained in each of their cells. From those two collums I am trying to obtain a total into a third collum by using the function:

=IF(AND(ISBLANK(H4),ISBLANK(I4)),"",K3+H4+H3

but it gives me a #VALUE! error

If anyone can help, please

Michael

 

[Dave R.]

The only part I can see that would lead to that error, is that k3, h4 or h3
do not contain numbers (at least not as Excel thinks). I assume this works
OK for when both I4 and H4 is blank.

I am trying to create a registry for tracking mileage. I have two collums:

One titled "Personal Miles" and the other titled "Business Miles". Both of
these collums have the conditional "IF" function contained in each of their
cells. From those two collums I am trying to obtain a total into a third
collum by using the function:

 

[Alan]

It works OK for me unless I enter a text item in H4 or I4
Regards,
Alan.

I am trying to create a registry for tracking mileage. I have two collums:

One titled "Personal Miles" and the other titled "Business Miles". Both of
these collums have the conditional "IF" function contained in each of their
cells. From those two collums I am trying to obtain a total into a third
collum by using the function:

 

[Dave R.]

I dont see why it would care if theres text in I4 since it's not being
added, but I can see that if there were text in the cells to be added it
wouldn't work.

 

[Alan]

You're right, only if there's text in H4

I dont see why it would care if theres text in I4 since it's not being
added, but I can see that if there were text in the cells to be added it
wouldn't work.

 

[sam]

Are the cells formated correctly?
-sam

-----Original Message-----
The only part I can see that would lead to that error, is that k3, h4 or h3
do not contain numbers (at least not as Excel thinks). I assume this works
OK for when both I4 and H4 is blank.



I have two collums:
One titled "Personal Miles" and the other

titled "Business Miles". Both of