Why do I get 0.00 for "" in a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get the correct (blank) response for this formula:
=IF(ISNUMBER(DAVERAGE(EXT_DAILY_DATA,EXT_AIM_ACHIEVED_CLAMPED_START,APR_CRITERIA)),DAVERAGE(EXT_DAILY_DATA,EXT_AIM_ACHIEVED_CLAMPED_START,APR_CRITERIA),"")

but I get an incorrect response (0.00) for a formula created the same way:
=IF(ISNUMBER(DAVERAGE(EXT_DAILY_DATA,EXT_TIME_IN_START,MAR_CRITERIA)),DAVERAGE(EXT_DAILY_DATA,EXT_TIME_IN_START,MAR_CRITERIA),"")

I have already checked the cell formatting and it is the same.
 
The only possible explanation is that the second formula is calculating an
average that equals 0. Excel would not mistakenly return a 0 for a blank.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

averaging info from three columns 5
Reference cell values from other sheets in a function 2
increment cell reference in a formula 3
database median function???? 2
How can i do a range (>10,<20) in DAVERAGE (Excel)? 2
DAVERAGE criteria HELP!!!! 2
DAVERAGE, MIN, and MAX from another worksheet 2
I am trying to use the IF and SUMIF function on Excel 8

Back
Top