| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel only shows formula and not result | Excel Worksheet Functions | |||
| vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
| The formula shows in cell but not the result | Excel Discussion (Misc queries) | |||
| Cell shows only formula, no result | Excel Worksheet Functions | |||
| Formula shows as the result? | Excel Discussion (Misc queries) | |||
Linear Mode
