# FALSE in Excel spreadsheet

Closed
William - Feb 11, 2021 at 01:14 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 12, 2021 at 04:13 PM
Hello,

I wonder if anyone can tell me why I am getting a 'FALSE' entry from the following formula: -

=IF(\$E\$3=Sheet1!\$A\$1,Totals!E6,IF(\$E\$3=Sheet1!\$A\$2,Totals!H6,IF(\$E\$3=Sheet1!\$A\$3,Totals!K6,IF(\$E\$3=Sheet1!\$A\$4,Totals!N6,IF(\$E\$3=Sheet1!\$A\$5,Totals!Q6,IF(\$E\$3=Sheet1!\$A\$6,Totals!T6))))))

What bothers me is that it has not given me problems before.

System Configuration: Windows / Chrome 88.0.4324.150
Related:

## 1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 12, 2021 at 04:13 PM
William, Good evening.

Look to your formula at last IF.

Is missing what to do when \$E\$3 is <> from Sheet1!\$A\$2........Sheet1!\$A\$6

Tell us if it worked for you.
Hope it helps.
--------
Belo Horizonte, MG - Brasil.
Marcílio Lobão