I’m completely lost with the formulas. I’m trying to write a formula that gives specific words in a cell a numerical value.
If “shoot booked” = “Standard Shoot” then the value is £45.00
If “shoot booked” = “Platinum shoot” then the value is £75.00
Help please and thank you!!