Originally Posted by Gord Dibben

How does D4 come into play? Or is it a dependent of I4?

Looks to me like the error would arise when I4 is empty or 0

Try this to give a message if I4 is empty.

=IF(I4="","There is no entry in I4",IF((G4+H4)0,(I4-F4)/I4,0))


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 19:07:28 +0100, Les Linton
wrote:


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