Hi Guys, I’m completely lost with the formulas. I’m trying to write a formula that gives specific words in a cell a numerical value. For example: If “shoot booked” = “Standard Shoot” then the value is £45.00 If “shoot booked” = “Platinum shoot” then ...