Trying to add a column then divide by the number in a cell in a different column. I want to get rid of the #DIV/0! error when there isn't any data in the cells.
Trying to add a column then divide by the number in a cell in a different column. I want to get rid of the #DIV/0! error when there isn't any data in the cells.
Please try
...IFError( your old formula , 0 )
or
IF( divider = 0 , 0 , your old formula )
Regards.
My English is very poor, so please be patient >_<"
My Dynamic Related Dropdown post:
https://www.excelforum.com/excel-for...ml#post5657376
https://www.excelforum.com/excel-for...ml#post5655711
https://www.excelforum.com/excel-for...ml#post5655762
Here is what I'm using "=IFERROR(G2:G14/F15,0)". Using this I don't get an error but the formula doesn't work.
Could you please upload a sample file ? (See the yellow banner above)
Regards.
Spreadsheet is attached.
Please try at G15
PS: I don't know the purpose of this cell, result may un-useable or did not make sense.Please Login or Register to view this content.
Regards.
Last edited by menem; 11-26-2019 at 11:14 PM. Reason: Remove wrong answer
When I use that formula I get 0.0, so the formula isn't working.
The purpose of the F15 cell is to divide the pieces by the number of workers.
In G!5, can't you just use:
=IFERROR(D15/F15,0)
I will try that, this is what I used =IFERROR(SUM(G2:G14)/F15,0)
You are right, I must have been asleep to miss that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks