I am trying to join these to formulas together but keep getting a FALSE statement in the target cell
What I want to accomplish is if the these 3 cells are blank it will say NO RECORD in the target cell
=IF(OR(ISBLANK(F2),ISBLANK(G2),ISBLANK(H2)),"NO RECORD",
&
=IF(OR(F2="NA",G2="NA"),SUM(F2:H2)&" (PROFILE)",IF(OR(H2="Walk",H2="Swim",H2="Bike"),SUM(F2:H2)&" (ALT EVENT)",SUM(F2:H2)))
Bookmarks