My Formula looks incorrect

Adriane Price
Adriane Price ✭✭✭✭✭✭
in Formulas and Functions

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

image.png

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:


image.png


Thank you!!

Adriane

Tags:
· Share on FacebookShare on Twitter

Best Answer

Answers

  • J Tech
    J Tech ✭✭✭✭✭

    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!
    · Share on FacebookShare on Twitter
  • Adriane Price
    Adriane Price ✭✭✭✭✭✭
    Answer ✓

    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

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!