how do i correct this error

[Darts via OfficeKB.com]

=IF((C14/B14)," ",(C14/B14) this returns #DIV/0!

 

[Pete_UK]

Try it this way:

=IF(B14=0,"",C14/B14)

Hope this helps.

Pete

 

[Sheeloo]

Try
=IF(B14=0,"",C14/B14)

 

[Darts via OfficeKB.com]

Pete thanks work great!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[Darts via OfficeKB.com]

Thanks works great!!!

Try it this way:

=IF(B14=0,"",C14/B14)

Hope this helps.

Pete

 

[Shane Devenshire]

Hi,

You can follow the syntax you originally started, so to speak with

=IF(B14,C14/B14,"")

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Satti Charvak]

You had basically exchange the parameters,

=IF((C14/B14),C14/B14," ")

is the correct one than your,

=IF((C14/B14)," ",(C14/B14))


Please select yes, if this post was useful

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete