if formula with 4 columns

[sthshrmags]

Hello,
hoping you can help me.

i would like to add to the basic if statement in my attached column M to say if the result of this if statement is 0 then give me Q.

The statement i currently have is =if(p2=0,n2,p2)

I am sure this is simple but i have been staring at this formula for so long today i can't see it.

i always found this forum helpful.

i appreciate it.

[gak67]

Please Login or Register  to view this content.

[boopathiraja]

try this

=IF(IF(P2=0,N2,P2)=0,Q2,"")

[sktneer]

Another....

Please Login or Register  to view this content.