Forum Discussion
MS LIST : Formula based on two columns
Hi 🙂
I was wondering if someone could help me out with a calculated column. I would like a column to display ''A'' or ''B'' based on two other columns (''M3'' and ''M4'') if those are blanks. For the moment, I can do it for one column, so here is my formula :
=IF(ISBLANK([M3]),"A","B")
My question is : how to add M4 to the formula ? So if M3 and M4 are blanks, then A, otherwise B ?
Kindly,
Audrey
AudreySC use this: =IF(AND(ISBLANK([M3]),ISBLANK([M4])), "A", "B")
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)
- Rob_ElliottBronze Contributor
AudreySC use this: =IF(AND(ISBLANK([M3]),ISBLANK([M4])), "A", "B")
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)- AudreySCCopper ContributorAmazing thank you !!!