error with If statement

[mateofeo]

Dear all
having an issue with the following:


In cell c1, the formula is if(a1="","",a1+b1)

if I copy that formula down the column of C, i get the #value! error. I looked in the help section but i dont get the answers.. any ideas?

thanks

 

[Gerhardc]

re: error with if statement

i have tested your formula and it works fine with me. What i can sugest ( not that it should make a diffrence) is to make sure that all 3 collums have the same cell format, ie: number or genaral , etc.

good luck

 

[Gerhardc]

#value error

Hi

I had a re-look at that formula. If your collum A is a string and not a value then you will get that error. Now i can only assume what you wana do is that if A have something typed in you want the value of B to be taken to C.
If this is so then change your formula to read as so: if(a1="","",b1).