Forum Discussion
Excel Formula
Danny116_ Which two formulae?
Riny_van_Eekelen let me see how best i can explain this. so in the attachment, column H (days open) i need it to reflect on column D (open/close). so if column D says Closed then the days open should reflect F3-B3 but if column D says open then it should reflect C3-B3. if you look at the data sheet at H3 & H4 it have the two formula in there but to add those two together based on reflecting open or close is the issue
You are so very close to the solution. All I had to do was combine your two IF statements, condition and outcome, into a single IFS, as shown below:
=IFS(
[@[Open/Closed]]="closed", first condition
[@[DATE DELIVERED]]-[@[DATE REQ]], first formula
[@[Open/Closed]]="OPEN", second condition
C3-[@[DATE REQ]] second formula
)
