+10Hello everyone! I need to modify a formula that I have because I want to calculate a result in column A when B is greater than C AND also if B is blank. This is the formula I’m currently using and it needs modification: IF({DeStaging Date}<{Monthly Rental Fee Renewal Date},BLANK(),DATEADD({Staging Date},46,‘days’))
+27IF(
OR(
NOT({DeStaging Date}),
{DeStaging Date} > {Monthly Rental Fee Renewal Date}
),
DATEADD({Staging Date},46,'days')
)
IF(
OR(
NOT({DeStaging Date}),
{DeStaging Date} > {Monthly Rental Fee Renewal Date}
),
DATEADD({Staging Date},46,'days')
)
Thank you so much!!! I greatly appreciate it!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.