Forum Discussion
Solved
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...
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.
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.
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.