Forum Discussion
Solved
remove #n/a in an ifs formula
hi,
I have done an ifs formula which has worked but it is returning #n/a error for the cells that doesn't meet the criteria. I need to remove #n/a error as i need to link this in to another formula i have tried using iferror formula but it didn't work for me. Can anyone help me with what formula i should use?
rach1345 Wrap the entire formula in IFERROR, liker this:
=IFERROR(IFS(------------),"")
By the way,
=IF(OR(LEFT(A2,3)="SIR",LEFT(A2,3)="NIR"),"GBMSTRAV","")
seems to give the same result.
rach1345 Wrap the entire formula in IFERROR, liker this:
=IFERROR(IFS(------------),"")
By the way,
=IF(OR(LEFT(A2,3)="SIR",LEFT(A2,3)="NIR"),"GBMSTRAV","")
seems to give the same result.
- Thank you : )
