why giving me N/A?

[daveyc18]

=IF(OR(G8=0,AB8>0),0,AB8)

g8 is N/a....AB8 is 0.....shouldnt the if statement produce 0? it's giving me N/A

 

[Michael M]

N/a is not a zereo !!
If N/a is a possiibility, try

=IF(OR(G8=0,G8="N/a",AB8>=0),0,AB8)

 

[daveyc18]

N/a is not a zereo !!
If N/a is a possiibility, try

=IF(OR(G8=0,G8="N/a",AB8>=0),0,AB8)

it's not text n/a but excels #n/a error

 

[Jonmo1]

it's not text n/a but excels #n/a error

#N/A error is still NOT a 0.
You have to test the cell for error

Try

=IF(ISNA(G8),0,IF(OR(G8=0,AB8>=0),0,AB8))

 

[Jon Peltier]

so

=IF(OR(G8=0,ISNA(G8),AB8>=0),0,AB8)

or

=IF(OR(G8=0,G8=#N/A,AB8>=0),0,AB8)

 

[MARK858]

Hi JP, are you getting 0 returned for a #n/a error in G8 with those formula?

 

[daveyc18]

ya not working for me...


yah, i know N/A isn't zero, which is why i thought the original formula would work.

in my original formula...i thought excel would be smart enough to decide that if g8 is NOT 0 (which means N/A falls into that category) OR if AB8 is NOT greater than 0, it would directly look at the value of ab8.

 

[daveyc18]

#N/A error is still NOT a 0.
You have to test the cell for error

Try

=IF(ISNA(G8),0,IF(OR(G8=0,AB8>=0),0,AB8))

this works thanks

 

[Jonmo1]

You’re welcome

 

[Jon Peltier]

I get 0 from the formula if G8 is #N/A, or if G8 is zero, or if AB8 is > zero. I thought it was funny you'd want 0 if G8 is not zero, but that's the formula you posted.