If/Then Division Formula

ccarlson113131

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?

Andrée Starå

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

 

ccarlson113131

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.

Andrée Starå

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?

ccarlson113131

It worked! Thank you!!

Andrée Starå

Excellent!

Happy to help!

ccarlson113131

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?

Andrée Starå

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?

ccarlson113131

It worked. Thank you so much!!

Andrée Starå

I'm always happy to help!