Formula for Sales Commission

[Cerebrus]

Good Morning,

I have a spreadsheet that tracks exchanges in sales.

I get paid 1% comms on all exchanges, but if I reach 100% exchanges for the month I get 1.5%

The cell that gives me the percentage has =J2/J1 (J3)

The cell that has my current comms is manually added and contains a number (D49).

The cell I want to return the comms (D50) if at 100% needs to be, if J3 is 100, then D49*1.5


I cant get it to show me a value other than what is currently in D49.

Any help would be greatly appreciated

 

[Sufiyan97]

Try in D50

=IF(J3=100,D49*1.5,D49)

 

[Cerebrus]

Thats what I had, and it was returning just D49

But I just spotted what it was, it was the % sign. As soon as I added that in it worked perfectly. God dammit haha

Thank you

 

[Sufiyan97]

Glad you sorted it.