How can I make this formula work?

Copper Contributor

=IF(B9=D9,E9+G9),IF(B9=H9,I9),IF(B9=J9,K9)

 

Today BUS11BUS 22Wednesday3Today5

B9                      D9        E9                G9          H9            I9       J9         K9

 

This part works =IF(B9=D9,E9+G9)

1 Reply

@RDC-1 

=IF(B9=D9,E9+G9,IF(B9=H9,I9,IF(B9=J9,K9,"nothing")))