basically I have to enter the number 1 in a cell to avoid getting the 'cant divide by zero' message, I'd like excel to assume that if the cell is left blank then the value is 1
the formula in the cell just now is "=P5/Q5*R5" but if r5 is left blank then it returns a 'cant divide by zero' error
I tried entering "=P5/Q5*R5 and if r5=0 then r5=1" which kinda makes sense to me but I don't really know much about excel and that doesn't work, just brings back an error
I would just enter the number 1 everytime if i have to but theres about 20 rows with the formula so 1 would need to be entered on every row so the total of all the rows doesnt return the 'cant divide by zero message' too
help please :d
the formula in the cell just now is "=P5/Q5*R5" but if r5 is left blank then it returns a 'cant divide by zero' error
I tried entering "=P5/Q5*R5 and if r5=0 then r5=1" which kinda makes sense to me but I don't really know much about excel and that doesn't work, just brings back an error
I would just enter the number 1 everytime if i have to but theres about 20 rows with the formula so 1 would need to be entered on every row so the total of all the rows doesnt return the 'cant divide by zero message' too
help please :d
