Several blanks, need to fill consecutively based on if and isblank statements

[FMulho]

Trying to fill a column per these rules:

IF [Major] ISBLANK use [Super]
IF [Super] ISBLANK use [Client]
IF [Client] ISBLANK use

<sub>I just tried the following, but was told there are too many arguments:

=IF(OR( [Major]="", ISBLANK( [Major] )), IF(OR( [Super] ="", ISBLANK( [Super])), IF(OR( [Client] ="", ISBLANK( [Client])), , [Client], [Super]), [Major] )

I have used the formula with success across 3 columns of data, but this 4th column is causing issues.

Could do multiple instances, but would like 1 formula if possible.</sub>

 

[hernantorres23]

Hi, forum team would pleasure for help you, but please try prepare a data example using add-in specifically for this and it can be found here XL2BB
Pay attention to this post XL2BB 2 Squares

Thanks a lot