Multiple IF statements in one cell

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

Image

Answer
Answer

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

•Beware of Scammers posting fake Support Numbers here.

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 13, 2025 Views 35 Applies to: