Multiple Cells Used Formula

[Chele83]

Good morning. I have been trying to create a formula for one cells value to be dependent on verbiage in another cell.

End goal is: if H1 text is unsatisfactory, then I1 would equal G1 + 5days; if H1 text is satisfactory I1 would equal G1 + 15days; if H1 text is excellent I1 would equal G1 + 30 days.

A​	B​	C​	D​	E​	F​	G​	H​	I​	J​
		P	H			09/11/2021	Unsatisfactory
		P	L			11/05/2021	Excellent
		R	B			11/06/2021	Satisfactory

I appreciate any help or assistance with this.

 

[AlanY]

how about?

Book1
	A	B	C	D	E	F	G	H	I
1			P	H			9/11/2021	Unsatisfactory	9/16/2021
2			P	L			11/5/2021	Excellent	12/5/2021
3			R	B			11/6/2021	Satisfactory	11/21/2021
Sheet1

Cell Formulas
Range	Formula
I1:I3	I1	=IF(LEFT(H1,1)="U",G1+5,IF(LEFT(H1,1)="S",G1+15,G1+30))

 

[Chele83]

how about?

Book1
	A	B	C	D	E	F	G	H	I
1			P	H			9/11/2021	Unsatisfactory	9/16/2021
2			P	L			11/5/2021	Excellent	12/5/2021
3			R	B			11/6/2021	Satisfactory	11/21/2021
Sheet1

Cell Formulas
Range	Formula
I1:I3	I1	=IF(LEFT(H1,1)="U",G1+5,IF(LEFT(H1,1)="S",G1+15,G1+30))

Thank you!
If the days added to G1 were to change, would it be as simple as changing the formula from
=IF(LEFT(H1,1)="U",G1+5,IF(LEFT(H1,1)="S",G1+15,G1+30))
to =IF(LEFT(H1,1)="U",G1+45,IF(LEFT(H1,1)="S",G1+180,G1+360))

 

[Fluff]

Yes that's right

 

[Chele83]

THANK YOU!!!!

 

[Fluff]

Glad we could help & thanks for the feedback.