If this, then that formula question

Melissa Logan

Hello! this may be so simple, but I'm having a hard time with it.

I want a few things to happen -

if the Approx trips per year is blank:

provide the sum of just the Registration price field & the Approximate travel field

If the Approv trips per year is NOT blank:

multiply the approx trips per year by the apprx travel cost, then provide the sum of that travel cost and the Registration price

it feels like an if statement, but I always have a hard time with the NOT blank if statements.

L_123

That said, a more linear, spoken version of the formula would look like this:

=if(isblank([approximate trips per year]@row),[registration price]@row + [approximate travel cost]@row,[registration price]@row + [approximate travel cost]@row * [approximate trips per year]@row

The first one is just smaller and more efficient by reducing the number of references.

L_123

=[Registration Price]@row + [Approximate Travel cost]@row * if(isblank([Approximate Trips per year]@row),1,[Approximate Trips per year]@row

that should do it for you.

L_123

That said, a more linear, spoken version of the formula would look like this:

=if(isblank([approximate trips per year]@row),[registration price]@row + [approximate travel cost]@row,[registration price]@row + [approximate travel cost]@row * [approximate trips per year]@row

The first one is just smaller and more efficient by reducing the number of references.

Melissa Logan

That second one worked, thank you!