CODEWITHSUNDEEP
excelexcel-formula
user14807564
user14807564

Reputation:

Trying to remove the FALSE statement from Excel Formula

I have rite a formula which is not a perfect one but is providing me the accurate result from the the data. There is just one problem in it that it also gives the FALSE value in the formula.

Which i want to remove If someone expert can do this i will appreciate the help or can provide the perfect formula that will be great help.

Please have a look on the below attached sheet.

Here is the formula

=IF(AND(C10<>$B$2,D10=7),"Y"&C10,IF(OR(D10=2,D10=5,D10=8,D10=11),IF($B$2=C10,"Q"&INT((D10-1)/3)+1&" "&C10),""))

and that False should not appear.

enter image description here

https://docs.google.com/spreadsheets/d/1I3tGNecvQ7Kqt0bGDX1Rxdw2sveZuPddfUjE8I2ZzFM/edit#gid=0

Upvotes: 0

Views: 9850

Answers (3)

Ashgabat
Ashgabat

Reputation: 81

To get rid of "FALSE" you need to type ,"" after the last C10 in your formula.

Upvotes: 0

norie
norie

Reputation: 9857

You are missing the false part of one of the IF statements, try this.

=IF(AND(C10<>$B$2,D10=7),"Y"&C10,IF(OR(D10=2,D10=5,D10=8,D10=11),IF($B$2=C10,"Q"&INT((D10-1)/3)+1&" "&C10,""),""))

Upvotes: 1

Chris Strickland
Chris Strickland

Reputation: 3490

You need to add a blank condition for when the third if statement is false.

=IF(
    AND(C10<>$B$2,D10=7), 
    "Y"&C10,
    IF(
        OR(D10=2,D10=5,D10=8,D10=11),
        IF(
            $B$2=C10,
            "Q"&INT((D10-1)/3)+1 & " "&C10,
            ""
        ),
    ""
    )
)

Upvotes: 0

Related Questions