Infinity values due to division

[mn75224]

Hello, I am getting many infinity values in my data set with the following formula. I believe that it is because it is dividing by 0 and not knowing NOT to divide by 0.

Inspection Cost per Mile = IF(NOT(ISBLANK([Length Miles])),[Inspection Total]/[Length Miles],BLANK())

[Greg_Deckler]

@mn75224 Use the DIVIDE function as it is designed to handle things like this.