Working with the "IF" function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.



Michael of Hanson said:
I am trying to create a registry for tracking mileage. I have two collums:
Click to expand...
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:
 
It works OK for me unless I enter a text item in H4 or I4
Regards,
Alan.
Michael of Hanson said:
I am trying to create a registry for tracking mileage. I have two collums:
Click to expand...
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:
 
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.
 
You're right, only if there's text in H4
Dave R. said:
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.
Click to expand...
 
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
Click to expand...
titled "Business Miles". Both of
 
Back
Top