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
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.
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:
- FALSE in Excel spreadsheet
- Gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Google spreadsheet right to left - Guide
- Number to words in excel - Guide
- Formula spreadsheet definition - Guide
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
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
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
