#Div/0! in Max and Min

Post Reply
Big-Jay
Posts: 1
Joined: Mon Nov 29, 2021 6:56 pm
Location: NE England

#Div/0! in Max and Min

Post by Big-Jay »

I have a spreadsheet containing forty nine (49) rows and nine (9) columns.
The sheet is concerned with calculating data for my motor vehicle each time the petrol tank is filled.
The only problem I am facing is using MAX & MIN.
The problem arises when I attempt to show either the MAX or MIN, petrol price per Imperial Gallon in that particular column.
Because of calculated results in other rows and columns, I have the error #DIV/0!, when attempting to get, either the MIN or MAX in that particular cell
How do I use MAX or MIN and ignore the error in that cell.
I am new to spreadsheets and would appreciate any help that anyone could give me.
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2933
Joined: Wed Mar 11, 2020 5:31 pm

Re: #Div/0! in Max and Min

Post by SuperTech »

Please share your PlanMaker file in which you are getting this problem, and please also mention the problematic cell address for better understanding.

If you want to send it to us privately, please e-mail us at the forum[at]softmaker.com

Please also include the forum URL of this topic so that we can trace your e-mail.
viewtopic.php?f=383&t=22343
Post Reply

Return to “PlanMaker 2021 for Windows”