Home

How can I make this formula work?

%3CLINGO-SUB%20id%3D%22lingo-sub-443955%22%20slang%3D%22en-US%22%3EHow%20can%20I%20make%20this%20formula%20work%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-443955%22%20slang%3D%22en-US%22%3E%3CP%3E%3DIF(B9%3DD9%2CE9%2BG9)%2CIF(B9%3DH9%2CI9)%2CIF(B9%3DJ9%2CK9)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EToday%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EBUS1%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3EBUS%202%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3CTD%3EWednesday%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3EToday%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EB9%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20D9%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20E9%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20G9%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20H9%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20I9%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BJ9%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BK9%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20part%20works%20%3DIF(B9%3DD9%2CE9%2BG9)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-443955%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-444024%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20make%20this%20formula%20work%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-444024%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F319984%22%20target%3D%22_blank%22%3E%40RDC-1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3DIF(B9%3DD9%2CE9%2BG9%2CIF(B9%3DH9%2CI9%2CIF(B9%3DJ9%2CK9%2C%22nothing%22)))%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
RDC-1
Frequent Visitor

=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")))

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
17 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies