Help With Formular


#1

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 the value is £75.00

Help please and thank you!!


#2

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.