Forum Discussion
#Name? Error
I cannot figure out what is causing the #NAME? error in the formula below: =IF(E43="N",””,IF(AND(E43=”Y”,DataEntry!F185="Compact FMI",DataEntry!AP186=””, DataEntry!AU187=””),DataEntry!AP185-DataE...
DataEntry!F185 thru F187 could contain something other than Compact FMI; but for E43 thats what it needs to be.