Is there an excel formula that can calculate 50% of a value based on content of another column?

Fine.Im your salesman plus im make spreadsheet to keep an eye on my revenue.Here may be the breakdown with what you want:

Column F will be “Sales 1”, column HE is “Sales 2”, as well as column J is my “commission voucher”.

Easily sell an auto on my own , personal, my label will surface in “sales 1” as well as “sales 2” is going to be left clear.If i must split a deal, a label will show up in “Sales 2”.

I usually have a formula in position that may calculate my commission voucher towards column J but needed to know if you find there your formula that will split the figure throughout column J through 50% in the event that ANY IDENTIFY appears inside “Sales 2” column.

Enter this kind of in the ideal cell for the commission for the row.

=IF(G2=””, “”, J2/2)

This assessments G2 for a name and when it will not find one particular, the mobile phone will display nothing, even so, if some sort of name looks in G2, then the total amount in J2 (your ” transaction fee ” voucher) is divided by simply 2.

You have to have an “IF” affirmation.

To your J column, it’ll be something similar to this:=if(len(g2)=0, (your current formula), (your current formula)/2)

To be able to translate, IF along the belongings of G2 will be zero THEN actually there isn’t a name right now there so we receive the first formula providing you with the full commission DIFFERENT (there is a value around G2) all of us take ones commission blueprint and partition it through two.Simple, eh.