FALSE in Excel spreadsheet

Question

FALSE in Excel spreadsheet

Report

William - Feb 11, 2021 at 01:14 PM
Mazzaropi

Posts: 1877
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: February 12, 2021

- 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

FALSE in Excel spreadsheet
How to get rid of false in excel ✓ - Forum - Office Software
How to take a screenshot of excel spreadsheet - How-To - Excel
How to remove false in excel ✓ - Forum - Excel
Golf skins excel spreadsheet ✓ - Forum - Excel
Notification when excel spreadsheet is updated ✓ - Forum - Excel

1 reply

Reply Ask a question

Mazzaropi · Answer 1 · 2021-02-12T16:13:49-0500

Answer 1 / 1

Mazzaropi

Posts: 1877
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: February 12, 2021

139
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

FALSE in Excel spreadsheet

1 reply

Your reply

Subscribe To Our Newsletter!