FALSE in Excel spreadsheet

Report
-
Posts
1877
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 12, 2021
-
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

1 reply

Posts
1877
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 12, 2021
139
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!