SOLVED

# what formula to use ?

Copper Contributor

# what formula to use ?

so I'm trying to achieve a formula which if it read S it adds one day from the raised date and if 1 adds 7 days if 2 adds 15 and so on ? what formula do I use?

so In H9 if G9=S+1 to F9 or if G9=1+7 to f9 and so on ?

2 Replies
best response confirmed by AhmetHa (Copper Contributor)
Solution

# Re: what formula to use ?

For example

=F9+SWITCH(G9, "S", 1, 1, 7, 2, 15, 3, 31, 0)

Change 31 to the value you want to use if G9=3, and add more values as needed.

# Re: what formula to use ?

awesome worked for me thank you I had to put parenthesise "" for the 1 that equals 7 and 2 that's equals 15 and os on.
1 best response

Accepted Solutions
best response confirmed by AhmetHa (Copper Contributor)
Solution

# Re: what formula to use ?

For example

=F9+SWITCH(G9, "S", 1, 1, 7, 2, 15, 3, 31, 0)

Change 31 to the value you want to use if G9=3, and add more values as needed.
The text passage contains a question about a formula to use in Excel for adding a certain number of days to a date based on a condition, and it also contains an answer providing the formula and instructions for customization.
single_question_with_answer
Given a text passage, determine:
    1. If it contains a mathematical question (including word problems or calculations)
    2. If an answer to that mathematical question is provided in the text

First, describe the content structure you found in 1-2 sentences.

Then provide your analysis in the following format:
TYPE: <one of the following values>
- NO_QUESTION
- SINGLE_QUESTION
- SINGLE_QUESTION_WITH_ANSWER
- MULTIPLE_QUESTIONS
- MULTIPLE_QUESTIONS_WITH_ANSWERS
system
SOLVED

# what formula to use ?

Copper Contributor

# what formula to use ?

so I'm trying to achieve a formula which if it read S it adds one day from the raised date and if 1 adds 7 days if 2 adds 15 and so on ? what formula do I use?

so In H9 if G9=S+1 to F9 or if G9=1+7 to f9 and so on ?

2 Replies
best response confirmed by AhmetHa (Copper Contributor)
Solution

# Re: what formula to use ?

For example

=F9+SWITCH(G9, "S", 1, 1, 7, 2, 15, 3, 31, 0)

Change 31 to the value you want to use if G9=3, and add more values as needed.

# Re: what formula to use ?

awesome worked for me thank you I had to put parenthesise "" for the 1 that equals 7 and 2 that's equals 15 and os on.
1 best response

Accepted Solutions
best response confirmed by AhmetHa (Copper Contributor)
Solution

# Re: what formula to use ?

For example

=F9+SWITCH(G9, "S", 1, 1, 7, 2, 15, 3, 31, 0)

Change 31 to the value you want to use if G9=3, and add more values as needed.
user
The text passage contains a question about a formula to use in Excel for adding a certain number of days to a date based on a condition, and it also contains an answer providing the formula and instructions for customization.

TYPE: SINGLE_QUESTION_WITH_ANSWER