'How do I create a formula for "if value in one cell is 1 then multiply by 1 and so on?
I am a beginner at excel. I want to multiply a cell with a number as the input given in another cell.
- Cell A1 has the Input that is the duration(week/s) which is 1/2/3/4...
- Cell A2 has the Start Date(i.e. Monday)
- Cell A3 has the End Date(which is supposed to be Friday) which I want to calculate as per the number of weeks I enter in the Cell A1 Example: If the Start Date(A2) is 14-02-2022 and the Duration(A1) is 1 week, the End Date(A3) should be 18-02-2022.
I tried with =A1*IF(A2=1,1.0001, IF(A2=2,1.00026)), to which I got the results. But when I tried to add the formula for the further durations, it said that I have entered too many arguments for this function.
How can I write a formula to handle the multiple durations?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|