Shows Result With any Data

K

Killer

Hey all need some help on this formula

=(P13=P52)*2 + (Q13=P53)*((P13=P52)+1)

It's returning a result without any data in Cell P52 or P53

Is there away of not correting the forumula to not show anything until
there's a result in Cell P52 & P53
 
C

Carim

Hi,

What are you trzing to achieve ...?
Because there are some "unusual" elements in your formula :
....
(P13=P52)
(Q13=P53)
(P13=P52)

HTH
 
C

Carim

Hi,

What are you trying to achieve ...?
Because there are some "unusual" elements in your formula :
....
(P13=P52)
(Q13=P53)
(P13=P52)
???

HTH
 
Top