Hello -
I am wanting to create a formula that will result in a value or zero based on the text of another cell. Example listed below has cell F2 resulting in "ZERO" which is fine. I also would like it to populate (C3*30) if the text in the C column is "STUDIO". Is there a way to do this automatically if I change the text in the C column? Thank you, any assistance is greatly appreciated

I am wanting to create a formula that will result in a value or zero based on the text of another cell. Example listed below has cell F2 resulting in "ZERO" which is fine. I also would like it to populate (C3*30) if the text in the C column is "STUDIO". Is there a way to do this automatically if I change the text in the C column? Thank you, any assistance is greatly appreciated
