+1Hi 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 the value is £75.00
Help please and thank you!!
Something like this?
The formula is:
IF(Type='Standard', 45, 75)
If you don’t want a default value, or if you want more types, you could make a concatenated IF formula, or even create a new Prices table, to convert the Type field to a Linked Record and convert the Value field to a Lookup.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
