I have my project inventory sheet working other than a divide by 0 error #DIV/0! when they don't enter a value in the quantity field.

Is it possible to move the cursor to the quantity field and display a message with this error?

Or, is it time to start learning VB?

This is the code that calculates the sales margin and gives the error

=IF((G4+H4)0,(I4-F4)/I4,0)

The quantity cell is D4

Thanks for your help,

Les