#Div/0! error

[akber.431]

Can anyone how can i get rid off the #Div/0! error

actually i need to know the percentage of sold Item, so i m dividing Sold item (amount)/Gross Sales first excel is coming ok, and next its showing above error,


please help me out this on error,

thanks and regards
Akber

 

[Useful]

Hi chek references is ok

 

[dave3009]

#DIV/0 error is simply division by zero, if Sold Item is in A1 and Gross Sales is in B1 then

=IF(B1=0, "", A1/B1)

which will let the formula return a blank cell if the divisor is zero.

 

[Marcelo Branco]

You have to use absolute-reference to Gross Sales cell

Something like
=A2/$A$20
copy down

assuming Gross Sales in cell A20

M.

 

[akber.431]

#DIV/0 error is simply division by zero, if Sold Item is in A1 and Gross Sales is in B1 then

=IF(B1=0, "", A1/B1)


which will let the formula return a blank cell if the divisor is zero.

sorry i tried but its not working

this is my equation



A B C
1- Qty Amount Mis%
2- 8.00 1,400.00 3% (formula =b2/b*100)
3- 19.00 820.00 2% (i encoded manual other wise #DIV/0)



10 Gross Sales 42196

 

[akber.431]

You have to use absolute-reference to Gross Sales cell

Something like
=A2/$A$20
copy down

assuming Gross Sales in cell A20

M.

how can i use that
can you explain me.
thanks

 

[njimack]

=B2/B$10
(you don't need to multiply by 100, just format as a percentage)

 

[akber.431]

thanks