K kaleigh297 New Member Jul 13, 2023 #1 How do I use the ifferror command to display different phrases depending on which type of error it was in the cell?
How do I use the ifferror command to display different phrases depending on which type of error it was in the cell?
AlanSidman Well-Known Member Jul 13, 2023 #2 Show us some sample data 8-12 records and a mocked up solution of what you expect. Do not post pictures as they can not be manipulated.
Show us some sample data 8-12 records and a mocked up solution of what you expect. Do not post pictures as they can not be manipulated.
Debaser Well-Known Member Jul 13, 2023 #3 You don't use IFERROR if you need a different response for different errors. There are other functions for that - eg you may want ERROR.TYPE depending on how many different types you need to identify.
You don't use IFERROR if you need a different response for different errors. There are other functions for that - eg you may want ERROR.TYPE depending on how many different types you need to identify.