aerospace1
New Member
- Joined
- Jun 21, 2019
- Messages
- 6
Hello, I am trying to figure out why Excel is giving me errors about the new formulas that I am creating. I have an original formula that works and gives me updates:
=IF($B$3="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code ",$B$3," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1))
I am trying to also add $B$4 on to it as well. I've tried multiple ways of doing this and it is either saying "#value" or "You've entered too many arguments for this function". Down below would be the multiple ways that I have done it and gave me the errors stated previously:
=OR(IF($B$3="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code ",$B$3," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1)),IF($B$4="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code ",$B$4," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1)))
=IF(OR($B$3,$B$4)="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code ",OR($B$3,$B$4)," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1))
Is there a way to include $B$4? This formula is to populate a chart title that I created. For example, I am working with 2 slicers that changes the title of the graph based on what I have selected. I am also trying to include a 3rd slicer (that is where $B$4 comes into play) to work with in the title. Any solutions?
=IF($B$3="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code ",$B$3," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1))
I am trying to also add $B$4 on to it as well. I've tried multiple ways of doing this and it is either saying "#value" or "You've entered too many arguments for this function". Down below would be the multiple ways that I have done it and gave me the errors stated previously:
=OR(IF($B$3="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code ",$B$3," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1)),IF($B$4="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code ",$B$4," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1)))
=IF(OR($B$3,$B$4)="(All)",CONCATENATE("Code ",$B$2," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1),CONCATENATE("Code ",OR($B$3,$B$4)," - Top Skills & Retirement Eligibility as of "&'Date for Charts'!C1))
Is there a way to include $B$4? This formula is to populate a chart title that I created. For example, I am working with 2 slicers that changes the title of the graph based on what I have selected. I am also trying to include a 3rd slicer (that is where $B$4 comes into play) to work with in the title. Any solutions?