msword
New Member
- Joined
- Oct 23, 2020
- Messages
- 46
- Office Version
- 2019
- Platform
- Windows
- MacOS
I am creating the "currency exchange" sheet for 2023. The problem is that I am getting the "#DIV/O!" error for future monthes (e.g. December) or any empty monthes in the past (e.g. January). Therefore, the =AVERAGE() exchange rate for the whole year 2023 is also became broken with the "#DIV/O!" error automatically.
The solution to that might be to avoid empty cells during =AVERAGE() calculation, but how to achieve that?
The solution to that might be to avoid empty cells during =AVERAGE() calculation, but how to achieve that?