ExcelBanter - Shows Result With any Data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Shows Result With any Data (https://www.excelbanter.com/excel-discussion-misc-queries/171844-shows-result-any-data.html)

Killer

Shows Result With any Data

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

Carim[_2_]

Shows Result With any Data

Hi,

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

HTH

Carim[_2_]

Shows Result With any Data

Hi,

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

HTH

David Biddulph[_2_]

Shows Result With any Data

=IF(OR(P52="",P53=""),"",(P13=P52)*2 + (Q13=P53)*((P13=P52)+1))
--
David Biddulph

"Killer" wrote in message
...
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

All times are GMT +1. The time now is 12:30 AM.