So I am creating a data results tab that pulls data from tabs where data is collected/recorded. In the data results tab, if the cell is blank (nothing was selected from the drop-down), I want it to populate with "No Dominant Root Cause was Assigned." If it is populated, I want it to return the value that it is populated with.
All the formulas I have found allow you to return the text when the cell is blank, or certain values based on the values of the cell, but not the exact value of the source cell. For example:
=IF(RA!P8<>"","No Dominant Root Cause was Assigned") -- only works when the cell is blank
=IF(ISBLANK(RA!P8),"No Dominant Root Cause was Assigned", IF(RA!P8=0,"zero","other")), doesn't work because I need it to populate the actual value in the cell.
Theoretically, this is what I'm looking for:
=IF(AND(IF(RA!P8<>"","No Dominant Root Cause was Assigned"),IF(RA!P8=any other value,J10=RA!P8)))