Re: Help With Formular

408 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!!

1 Reply 1

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.