I am trying to find a way for google sheets to change the result of a division equation based on two different conditions. If it is dividing a 0 by a 0, I want it to be blank (so I use IFERROR and then leave it blank, that part is working).
Where I am struggling is when I want a 0 to show as the result IF it is dividing a number greater than 0 by 0.
Example: I am tracking qts of oil used per flight hour, and I have a column for each. If a plane flew for 10 hours and used 0 qts of oil, I want the result cell to show 0. If there is no data, the plane flew for 0 hours and used 0 qts, I want it to keep showing a blank cell.
TIA!
Tried to play around with the IFERROR and IF functions, but I am not good enough with sheets yet to figure it out.
Lindsey Brand is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.