mickeystanford_alumni
Board Regular
- Joined
- May 11, 2022
- Messages
- 129
- Office Version
- 2021
- Platform
- Windows
- MacOS
Hi again everyone,
Is there any way to convert all #DIV/0! into blank cells?
I have a big file and every sheet has some #DIV/0!.
I don't want to go one by one putting the =IFERROR(,0) then:
Is there any way to get rid of them? Also it would work if in all #DIV/0! I insert the =iferror formula, however, in an automated way? Guess that's not possible right?
Txs for any ideas.
Is there any way to convert all #DIV/0! into blank cells?
I have a big file and every sheet has some #DIV/0!.
I don't want to go one by one putting the =IFERROR(,0) then:
Is there any way to get rid of them? Also it would work if in all #DIV/0! I insert the =iferror formula, however, in an automated way? Guess that's not possible right?
Txs for any ideas.