Excel Multiple If statement

Question

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

An IF statement only takes 2 a TRUE our false evaluation. Your second IF needs to be a separate. — Wyatt Shipman
– Wyatt Shipman, Commented Feb 18, 2016 at 6:28

Wyatt Shipman · Accepted Answer · 2016-02-18 06:26:11Z

1

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

answered Feb 18, 2016 at 6:26

Wyatt Shipman

1,8091 gold badge13 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

deejay Over a year ago

BRILLIANT. thank you very much! it works. so basically what I need to do is "Multiply" if the statement is true. thank you so much

Alexandru Cimpanu · Accepted Answer · 2016-02-18 06:36:17Z

0

=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
}

edited Feb 18, 2016 at 6:36

answered Feb 18, 2016 at 6:30

Alexandru Cimpanu

1,0692 gold badges15 silver badges38 bronze badges

1 Comment

deejay Over a year ago

Thank you for giving time on answering my query how ever it doesn't work. thanks again

Moumit · Accepted Answer · 2016-02-18 07:30:36Z

0

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

edited Feb 18, 2016 at 7:30

answered Feb 18, 2016 at 6:32

Moumit

9,8709 gold badges59 silver badges66 bronze badges

2 Comments

deejay Over a year ago

thanks for answering, however the if A6 is false J6 still keeps the value from I6.

Moumit Over a year ago

What should happen if A6 is not true.. is it will be J6 = I6 ??

Collectives™ on Stack Overflow

Excel Multiple If statement

3 Answers 3

1 Comment

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related