Multiple IF statements in one cell

Question

Multiple IF statements in one cell

Anonymous

Hi,

Need to have multiple IF statements in one cell.

IF D12=D1 then E12 if not 0 IF D13=D1 then E13 if not 0 IF D14=D1 then E14 if not 0

D12-14 will be different dates.

With only one IF statement in cell D4, I get the correct value. =IF($D12=D1,$E12,0)

Also tried IFS statement. No go.

Please explain how I can have multiple IF statements in one cell using dates and amounts shown below.

Thanks,

Geir Karlsen

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

Answer accepted by question author

0 additional answers

Answer 1

Anonymous

=IF(D12=D1,E12,IF(D13=D1,E13,IF(D14=D1,E14,0)))

Share via

Multiple IF statements in one cell

0 additional answers