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