MIN MAX errors in excel when one of the cells is a blank cell rather then a number like zero
The MIN and MAX functions in Excel allow you to tell Excel to specify whether you want a minimum of a number of cells, or the maximum of a number of cells. However there is something that needs to be understood about these functions with regards MIN MAX errors in Excel.
What you have here is a very simple spreadsheet, there’s a Reserve requirement and then there’s Cash available, and the MIN is used to decide which is the minimum and that is how much is kept aside. So for example when you have 90 available that is the most you can put behind, but you need a 100 and so it goes on. And this stage you no longer require a reserve , you’ve got cash available but you don’t need to hold it in a separate account.
What’s important to know that when there’s a zero here, this calculation is again correct however if this was deleted and the reason this is mentioned is that people often associate an empty cell with a zero. So for example someone might say well let me
highlight these two
and delete them because they’re not required,
what happens is Excel ignores these empty cells and says well the minimum is now here it’s the 130
And this can cause problems in certain spreadsheets. So you just have to be careful to make sure that no empty cells are causing problems in your MIN and MAX features
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
AuditExcel (aka Miricle Solutions) provided the Sasol Chlor Vinyls financial team with professional excel training whilst fully understanding the accounting landscape which is highly recommend.– Sasol Polymers