Hello Mr Excel Forum
What is a formula for the following hypothetical scenario:
I get paid a fee for signing up users to a website. The base fee ($0.5)
For the first 1 million users who verify, I receive an additional fee ($0.5)
For 1 million to 2 million users who verify, my additional fee increases ($0.75)
For 2 million or more who verify, my additional fee increases again ($1.00)
Example: Let's say I sign up 4.5 million users and verify 3.5 million users
Sign ups result in a fee of $2,250,000 (4.5 million users signed up)
Up to the first million verifications result in a fee of $500,000 (1 million multiplied by $0.5)
The 1 million to 2 million verifications result in a fee of $750,000 (1 million multiplied by $0.75)
And the 1.5 million after the 2 million result in a fee of $1,500,000 (1.5 million multiplied by $1)
total fees to be received for 4.5 million sign-ups with 3.5 million verifications is: $3,250,000
A1 of the spreadsheet would be the total sign-ups.
A2 of the spreadsheet would be the total verified sign-ups.
Thank you in advance for all your help. I've been struggling with this for two days.
What is a formula for the following hypothetical scenario:
I get paid a fee for signing up users to a website. The base fee ($0.5)
For the first 1 million users who verify, I receive an additional fee ($0.5)
For 1 million to 2 million users who verify, my additional fee increases ($0.75)
For 2 million or more who verify, my additional fee increases again ($1.00)
Example: Let's say I sign up 4.5 million users and verify 3.5 million users
Sign ups result in a fee of $2,250,000 (4.5 million users signed up)
Up to the first million verifications result in a fee of $500,000 (1 million multiplied by $0.5)
The 1 million to 2 million verifications result in a fee of $750,000 (1 million multiplied by $0.75)
And the 1.5 million after the 2 million result in a fee of $1,500,000 (1.5 million multiplied by $1)
total fees to be received for 4.5 million sign-ups with 3.5 million verifications is: $3,250,000
A1 of the spreadsheet would be the total sign-ups.
A2 of the spreadsheet would be the total verified sign-ups.
Thank you in advance for all your help. I've been struggling with this for two days.