# If/Then Division Formula

Options
edited 12/09/19

I am trying to make a formula where IF the dropdown in row B selected is 50/50, THEN the dollar amount in row A is divided by 2. Does this make sense? Is there a way to formulate this?

• ✭✭✭✭✭✭
Options

Hi,

Do you mean columns or rows?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

I want the Total to be if 100%, then Total Dollar stays the same. If 50/50, then Total is Total Dollar Amount divided by 2.

• ✭✭✭✭✭✭
Options

Ok.

Try something like this.

=IF(Billing@row = "50/50"; [Total Dollar Amount]@row / 2; [Total Dollar Amount]@row)

The same version but with the below changes for your and others convenience.

=IF(Billing@row = "50/50", [Total Dollar Amount]@row / 2, [Total Dollar Amount]@row)

Depending on your country, you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work, or did I misunderstand?

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

It worked! Thank you!!

• ✭✭✭✭✭✭
Options

Excellent!

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

I apologize, one more question. If I wanted to add another rule to that statement where it would say if it's 100% Distributor in the dropdown, then the total is 0, how would I add that in so that there's two rules for that cell?

• ✭✭✭✭✭✭
Options

No worries!

Try something like this.

=IF(Billing@row = "50/50"; [Total Dollar Amount]@row / 2; IF(Billing@row = "100% Distributor"; 0; [Total Dollar Amount]@row))

The same version but with the below changes for your and others convenience.

=IF(Billing@row = "50/50", [Total Dollar Amount]@row / 2, IF(Billing@row = "100% Distributor", 0, [Total Dollar Amount]@row))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

It worked. Thank you so much!!

• ✭✭✭✭✭✭
Options

I'm always happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.