I have a SP list that contains software installation data. There is a calculated column that calculates price. There is a column called Installation Date which has 2 choices either Before Sep 30, 2020 or After Sep 30, 2020 in String. There is a request type field which has 2 choices New or Renew. The Charge Date field contains Date.
I created this formula which works but is missing the logic to filter Request Type field. I wanted some assistance on updating the IF statement.
=IF([Installation Date]="Before Sep 30, 2020",[Lic Qty]*750,(([Lic Qty]*430)/TEXT([Charge Date],"mm")))
- For Software installed before Sep 30, 2020 and Request Type is New: cost will be $750
- For Software installed before Sep 30, 2020 and Request Type is Renew: cost will be $430
- For Software installed After Sep 30, 2020 : Price will be $430 per license per year. Pro-rated for the current year.
Thank you for your time.