Hello, I am a pro writer for companies and I am looking to generate quotes automatically.
Depending on type of report (4 types) selected by the customer AND the time of writing (full day or half day) the price will vary.
I want to convert this example to formulas :
If half day and very synthetic = price 1
If day and very synthetic = price 2
If half day and abbreviated summary = price 3
If day and abbreviated summary = price 4
If half day and standard synthesis = price 5
If day and standard synthesis = price 6
If half day and exhaustive = price 7
If day and exhaustive = price 8
I have already created in my table, 2 columns:
- one indicating the type of report (very synthetic, abbreviated summary, standard synthesis, exhaustive)
- the second indicating if it's half or full day
I am therefore trying to create a formula that will check in my columns "full day or half day?" AND "Type of report ?" in order to show a price.
Do you have the possibility to help me please?
Have a good day
