My Formula looks incorrect

Adriane Price

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 Price

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)

J Tech

Try this one

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

Adriane Price

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)