Why does this not work?

A

Alex Hammerstein

Hi I have the following formula which works a treat in Excel 2007, but
returns a #Value error when opened in Excel 2008?

=IF(TASK2!$G6="completed",(IF(TASK2!$I6<40,"fail",
IF(TASK2!$I6>69,"distinction", "pass"))),"")

Sorry about the wrap

Thanks for any info

Alex
 
B

Bob Greenblatt

Hi I have the following formula which works a treat in Excel 2007, but
returns a #Value error when opened in Excel 2008?

=IF(TASK2!$G6="completed",(IF(TASK2!$I6<40,"fail",
IF(TASK2!$I6>69,"distinction", "pass"))),"")

Sorry about the wrap

Thanks for any info

Alex
Click to expand...
What cell is it in? What is in the referenced cells? Have you tried
highlighting each section of the formula in the formula bar and then
pressing F9?
 

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

Why does this not work (2) 2
if function error 3
How does this formula work ? 2
does acces support 'if' statements for multiple parameters? 5
Excel not calculating properly 2
Excel PRICE function: How does it compute Issue Date of the Security 5
FileSystemObject does not work on SharePoint 2
Same experience 0

Top