CODEWITHSUNDEEP
excelif-statementformula
deejay
deejay

Reputation: 57

Excel Multiple If statement

Good Day,

Please let me know what is the mistake I made on this formula.

=IF(A6=TRUE,I6,0,IF(B6=TRUE,I6*1.2,I6))

basically what I want to do is, when A6 is true then J6 = I6 and if B6 is also true the value on J6 will be I6*1.2 if not it will remain as J6 = I6 .

Please see screenshot below enter image description here

Upvotes: 1

Views: 120

Answers (3)

Moumit
Moumit

Reputation: 9510

=IF(AND(A6=TRUE,B6=TRUE),I6*1.2,I6)

Upvotes: 0

Alexandru Cimpanu
Alexandru Cimpanu

Reputation: 1069

=IF(A6=TRUE, IF((B6=TRUE),I6*1.2, I6),0)

If A6 is TRUE then we check if also B6 is TRUE in the first IF condition. It's like this:

if(A6=TRUE)
{
    if(B6=TRUE)
    {
        I6*1.2
    }
    else
    {
        I6
    }
}
else
{
    0
}

Upvotes: 0

Wyatt Shipman
Wyatt Shipman

Reputation: 1789

=IF(A6=TRUE,I6,0)*IF(B6=TRUE,1.2,1) Or =IF(A6=False,0,IF(B6=TRUE,I6*1.2,I6))

Upvotes: 1

Related Questions