Shows Result With any Data

  • Thread starter Thread starter Killer
  • Start date Start date
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
 
Hi,

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

HTH
 
Hi,

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

HTH
 
=IF(OR(P52="",P53=""),"",(P13=P52)*2 + (Q13=P53)*((P13=P52)+1))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Try to be more precise 4
Conversion of dates 3
Assistance with counting cells with numbers 2
Small problem with a line chart 2
Windows 7 Windows7 Remote Desktop Web Connection 4
Nested IF & MAX Function 4
Merging and formatting a cell in workbook_open 2
How to Differentiate between a Student's Score of "0" and a Score of Null? 6

Back
Top