Forum Discussion
emmapapa2
Dec 09, 2021Copper Contributor
QUESTION ABOUT EXCEL
For date from> = 08/20/1950 to display the value 80 and for date> = 09/20/1950 to <= 10/30/1998 to display the value 60 and for date> = 10/31/1998 to and <= 01/30/2008 to display the value 60! I appl...
- Dec 09, 2021
Here is the sample workbook.
HansVogelaar
Dec 09, 2021MVP
See the attached sample workbook.
emmapapa2
Dec 09, 2021Copper Contributor
This file is very useful, but I would like a way in which all this can operate automatically!
For example if I click region 1 ( in a cell) I take the result of the region 1. If 2 etc
For example if I click region 1 ( in a cell) I take the result of the region 1. If 2 etc
- emmapapa2Dec 10, 2021Copper ContributorThank you very much! I’ll try to use the sample workbook!
- HansVogelaarDec 10, 2021MVP
You can do that with the sample workbook.
- emmapapa2Dec 10, 2021Copper ContributorI have the areas that I sent you with the corresponding numbers!
I would like when one of my clients is from area 1, 2 or any other to be able to press the area to actually get me the result, so that I can use it in later calculations - HansVogelaarDec 10, 2021MVP
What's the point?
- emmapapa2Dec 10, 2021Copper ContributorI want a way like a choice !
For example if I choose the cell A1 with region 1 automatically I would like the excel calculate the result !
Like a multiple choice ! - HansVogelaarDec 10, 2021MVP
The sample workbook that I attached already returns K(x3) for all regions...