If Formula

[alhazen]

Hello guys,

I need your help to solve this formula. I use this formula if([Cadence]="weekly",
if(
isblank([add_date]),
[planned_start_date],
([add_date] + 7)),"") for an action "set values of some columns in this row".

how to combine above formula with other expression like 

if([Cadence]="monthly",
if(
isblank([add_date]),
[planned_start_date],
([add_date] + 30)),"")

and 

if([Cadence]="quarterly",
if(
isblank([add_date]),
[planned_start_date],
([add_date] + 90)),"")

I used "and" to combine them,  but it doesn't work. Thank you very much for your help

@Steve @TeeSee1 

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/2355953-if

https://help.appsheet.com/en/articles/2355961-ifs

https://help.appsheet.com/en/articles/2347624-and

https://help.appsheet.com/en/articles/2357288-or

[alhazen]

Thanks sir!