L
Les Linton
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
#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