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?
 
Top