#VALUE!

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

Guest

Using Excel 2000. There are several worksheets in this workbook. On the
'Summary' tab I have this formula in a cell:

=ROUND(IF(MAR!J3="","",MAR!J3),0), which is yielding #VALUE!

On the 'MAR' tab, in cell J3 (which the formula above refers to), there is
this formula:

=IF(COUNT(S43:S601)=0,"",AVERAGE(S43:S601)), which yields nothing because
there's nothing yet in S43:S601.

Why is the first formula yielding #VALUE! ? I want the cell to be blank
since there's nothing in cell J3 on the 'MAR' worksheet.

Connie Martin
 
Hi Connie

would re-writing your formula as
=IF(Mar!J13="","",Round(Mar!J3,0))
solve the problem?

Cheers
JulieD
 

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

forecast a financial value at year end 1
why doesn't excel count "numbers" in an IF formula 3
IF AND VLOOKUP formula needed 1
WORKDAY Function 3
Two vlookup questions 5
Duplicate Values in Excel 2007 6
VLOOKUP over three spreadsheets 8
SUMIF using value from MOD function 2

Back
Top