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))
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))
Outstanding! Thanks for your quick help Hans!
I just couldn't work out the order things needed to go in - knew there was something really simple I was missing.
I just couldn't work out the order things needed to go in - knew there was something really simple I was missing.