# My Formula looks incorrect

Options
✭✭✭✭✭✭

Hello,

I am attempting to get a Margin (%) for my outcome, however I have received "unparseable", "incorrect argument" "invalid" when attempting a few variations. Am I overlooking something?

I need to get my

The formula I am using in smartsheet:

=IF(ISBLANK([Customer Cost/Booking \$\$]@row - [Partner Cost \$\$]@row), "", /[Customer Cost/Booking \$\$])

So that the outcome would be in the margin column:

Thank you!!

Adriane

Tags:

## Best Answer

• ✭✭✭✭✭✭
Answer ✓
Options

Thank you, the below formula ended up working for my situation

=IFERROR(SUM([Customer Cost/Booking \$\$]@row - [Partner Cost \$\$]@row) / [Customer Cost/Booking \$\$]@row, 0)

Adriane

## Answers

• ✭✭✭✭✭
Options

Try this one

=IF([Customer Cost/Booking \$\$]@row="","",([Customer Cost/Booking \$\$]@row - [Partner Cost \$\$]@row), "", /[Customer Cost/Booking \$\$])

Regards

J Tech

##### If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
• ✭✭✭✭✭✭
Answer ✓
Options

Thank you, the below formula ended up working for my situation

=IFERROR(SUM([Customer Cost/Booking \$\$]@row - [Partner Cost \$\$]@row) / [Customer Cost/Booking \$\$]@row, 0)

Adriane

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!