MrExcel Publishing
Your One Stop for Excel Tips & Solutions

DGET function etc.. are not workingg


Posted by cindy on July 10, 2001 8:36 AM

i am using the Dget function.. i have five diff programs using this formulas but i am having problem with one.. it does not execute the Dget function which is working in other programs.. the conditions are the same.. but its still not working


Posted by Mark W. on July 10, 2001 8:43 AM

> ...it does not execute the Dget function...

Is your calculation set to manual? Check
the Calculation tab using the Tools | Options
menu command.

Is DGET evaluated when you press F9?

Posted by cindy on July 10, 2001 11:03 PM

calculation is set to automatic.. the Dget functions cannot find the items given the condition, the conditions and correct and the item is in the table still it cannot find the item

Posted by Mark W. on July 11, 2001 6:39 AM

Re: DGET function etc.. are not working

I'm guessing that all is not as it seems, but will need
specific info about data and criteria to be of much
help.