If this, then that formula question
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.
Best Answer

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.
Answers

=[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.

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.

That second one worked, thank you!
Help Article Resources
Categories
Check out the Formula Handbook template!