#Name? Error in select versions...

[andrewb90]

Hello All,

I've been going through my workbook to make it compatible for older versions, and one of the issues it flagged was saying that one or more functions isn't available in earlier versions and and will display a #Name? instead of the result.

Here is the only formula (filled down x 100 rows)

=IF(C5="","","*")&IF(C5="","",IF((MOD(IF(F5="CLOSE",Initial!$E$31,F5)-D5,1)*24)>=Initial!$F$52,"30",IF((MOD(IF(F5="CLOSE",Initial!$E$31,F5)-D5,1)*24)<Initial!$F$53,"N","15")))

There are only a few occurrences, so I'm at a loss to explain what could be causing it.

 

[Timjan]

If you are using the formula with vba, it should read,

=IF(C5="""","""","*")&IF(C5="""","""",IF((MOD(IF(F5=""CLOSE"",Initial!$E$31,F5)-D5,1)*24)>=Initial!$F$52,""30"",IF((MOD(IF(F5=""CLOSE"",Initial!$E$31,F5)-D5,1)*24)