davidroger
New member
- Joined
- Dec 17, 2013
- Messages
- 6
- Reaction score
- 0
- Points
- 0
I have three column of data.
One example: 2500, #n/a, #n/a (say a1,b1,c1)
I am using 'if' formula when any of the data consist of number not #n/a it would result of 0.
My formula is =if(or(a1>0,b1>0,c1>0),0,#n/a) and it show #n/a.
When I separate the formula is ok. =if(a1>0,0,#n/a) shows 0 and the other two show #n/a.
Any idea what went wrong?
One example: 2500, #n/a, #n/a (say a1,b1,c1)
I am using 'if' formula when any of the data consist of number not #n/a it would result of 0.
My formula is =if(or(a1>0,b1>0,c1>0),0,#n/a) and it show #n/a.
When I separate the formula is ok. =if(a1>0,0,#n/a) shows 0 and the other two show #n/a.
Any idea what went wrong?