Forum Discussion
Solved
Ignoring zero in IF formula
Hi all, I'm a novice in Excel so go easy on me, but this little thing has me pulling out my hair! I'm creating a scatter chart using error bars to draw between the scatter markers, so I need to tak...
For example
=IF(A3=0,0,IF(A3-A2<0,ABS(A3-A2),0))
or
=IF(OR(A3=0,A3-A2>=0),0,ABS(A3-A2))
