Hello
I could use some help using the IF statement and adding other criteria.
If a cell(C2) equates to days worked and cell (C3) equals the sum of credits as calculated below:
1 day worked =2 credits
2 days worked =4 credits
Any days worked over 2 days = 6 credits
Example:
1 day worked = 2 credits
2 days worked = 6 credits
3 days worked = 12 credits
4 days worked = 18 credits
Thank you
Bob
Last edited by AliGW; 04-17-2020 at 02:35 AM. Reason: Solved tag added - no need to edit thread title or add solved to post. Thanks.
Hi, welcome to the forum
We require that all thread titles are descriptive of your problem (ie, what you are trying to do). Pretty much everyone comes here for some kind of "formula help", so that doesnt tell us what you are trying to do.
As a new member, I would change it for you (this time), but I honestly have no idea what you are trying to do, so perhaps try explaining again?
Also, you can upload a dummy sample file, showing what you have, and what you want (see yellow banner at the top of the page)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry about that.
Thank You Ford.
I will give it another attempt
Thanks
Bob
This should make more sense
Trying to calculate the following:
For each item sold for the month a credit is awarded. I'm having a difficult time to calculating the credits due to the way the credits are awarded.
I used "days worked" in the example above....not good
The credit for selling an item is not a 1 for 1. It is compounded as follows:
-If 1 item is sold for the month = 2 credits are awarded (easy).
-If 2 items are sold for the month = 4 credits are awarded in addition to the 2 credits awarded for the first item sold. (2+4 =6 credits)
-If greater than 2 items are sold for the month = 6 credits are awarded for EACH item sold. So the third item sold would be an additional 6 credits added to the previous sales credits (2+4+6 = 12 credits). 6 items sold would be (2+4+6+6+6+6=30 credits)
So I'm trying to calculate total credits awarded at the end of the month.
Using 2 cells (lets say C1=sales and C2= credits) I'm having trouble with the formula.
I would also like to break it down by month. Each column representing a month, whereby a total credit would show at the end of a row (a row representing a name.
Example Row C =(name), JAN (C1=sales, C2+Credits) + FEB (C3=sale, C4=Credits) + etc etc. = Total credits (Cxx)
I have not made a sheet yet with all the months. Just trying to figure out the 2 cells (sales and credits)
I have tried using IF AND. Not having any luck with example formulas on the web.
Any help would be appreciated.
Ford...I'm not sure what the correct tile should be for this? Would gladly change it.
Thanks
Bob
I have updated the title - please bear rule #1 in mind in future.
There are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks Ali, had no clue how to title this 1 lol
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Alan
I attempted to do so but the site will not allow me to post a link.
Thanks
Bob
This is the formula thus far, which doesn't quite work.
Not able to upload a sample sheet at the moment.
=IF(B4=1,2)+(IF(B4=2,4)+(IF(B4>2,6)))
The IF statements work, I am not able to derive the formula to add them together.
Only using two cells = cell=Items sold and Cell=Credits.
To refresh what I'm trying to achieve:
1 item sold = 2 credits
2 items sold = 4 credits + the previous 2 credits = 6 credits
3 items sold = 6 credits + the previous 4 credits = 12 credits
Each additional items sold = 6 credits. E.g - 6 items sold = 2+4+6+6+6+6 = 30 credits
Thanks
Bob
Type the URL out. Do not try and cut and paste it. You cannot post links that way until you have sufficient posts.
Please read and understand the rules you agreed to when you joined.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
I did to type it. No luck. Still will not accept.
The question was also posted to the another site:
Excelguru.ca - Post tile = Formula Help - Tiered credits for items sold.
Mod Edit: https://www.excelguru.ca/forums/show...s-sold&p=43572
Last edited by AliGW; 04-16-2020 at 01:03 AM.
Here is the correct formula
=IF(B4>2,((B4-2)*6)+6,IF(B4=1,2,4))
Is it?Originally Posted by 10100m
That formula returns 4 when there are two items sold, but you wanted 6:
=CHOOSE(MIN(2,B4)+1,0,2,(B4-1)*6)
Last edited by p45cal; 04-19-2020 at 09:51 AM.
Correct P45cal Thank you.
The last part of the formula should have been IF(B4=1,2,6)
Thank for yours as well
Bob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks