How to correct a #DIV/0! error

[mirofa]

Hello again.
I use one sheet.
How can fix errror #DIV/0! from M column?
I enter a number in column F and divide it by the number from column L and get the final result in column M . You have an example of cells 7 in the photo.
Now, in that column L, apart from the number 10,400, I am not allowed to enter any other numbers.

Thanks in advance. If you need a more detailed explanation, write to me.

 

[hagia_sofia]

Hello, e.g.

=IF(L4=0,"",F4/L4)

 

[mirofa]

Hello, e.g.

=IF(L4=0,"",F4/L4)

He showed me this error.

 

[Joe4]

Are you using a version of Excel that using semi-colons instead of commas to separate function arguments?
If so, then your formula should be:

=IF(L4=0;"";F4/L4)

 

[mirofa]

Are you using a version of Excel that using semi-colons instead of commas to separate function arguments?
If so, then your formula should be:

=IF(L4=0;"";F4/L4)

You helped me, this works. Thank you

 

[Joe4]

You are welcome.
Glad we were able to help!

hagia_sofia did most of the work, I just updated the argument separators!

 

[mirofa]

You are welcome.
Glad we were able to help!

hagia_sofia did most of the work, I just updated the argument separators!

Now another problem happened to me in the same sheet.
In addition to these cells that we solved, I have another table that adds up those cells that we fixed.
Now i have an #VALUE! error .

Thanks in advance

 

[Phuoc]

Try this:

=IF(AF3=0;"";SUM(M4:M6)/AF3)

 

[bebo021999]

Now another problem happened to me in the same sheet.
In addition to these cells that we solved, I have another table that adds up those cells that we fixed.
Now i have an #VALUE! error .

Thanks in advance

View attachment 118171 View attachment 118172 View attachment 118173

Just because M4,M5 or M6 contains textstring Null ("") coming from formula
Try using N() to convert string to 0
=IFERROR((N(M4)+N(M5)+N(M6))/AF3,"")

or simply SUM

=IFERROR(SUM(M4:M6)/AF3,"")

 

[mirofa]

Just because M4,M5 or M6 contains textstring Null ("") coming from formula
Try using N() to convert string to 0
=IFERROR((N(M4)+N(M5)+N(M6))/AF3,"")

or simply SUM

=IFERROR(SUM(M4:M6)/AF3,"")

Done. I edit formula . From =IF(T4=0;"";F4/T4) to =IF(T4=0;0;F4/T4) and now works...
Thank you all for your efforts!