Forum Discussion

AudreySC's avatar
AudreySC
Copper Contributor
Oct 20, 2023

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

Microsoft Lists
  • Rob_Elliott's avatar
    Rob_Elliott
    Oct 20, 2023

    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_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Oct 20, 2023

    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)

Resources