How do I pull in rebate in column G ( after four quarters)? The Sale quarter is an input that can be changed, rebate recognition should change to after four quarters of sale and should do it automatically based on sale quarter.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Cell value depending on input in a different cell value
If somebody else can come up with a solution fine, but I would like to see input and output or what it is you want to see for the output of your problem. I would like to see what it is you want to see when all the data is entered.
Upvote
0
vdaesety we have our work cut out for us here. From how we set up our worksheet to what it is we want to accomplish. How and what data is going to be entered. When we enter data what happens. Now if you are planning to use Mr Excel web page it would be beneficial to download that XL2BB program. I am using it to enter the worksheet below. Now this is going to be a slow process. If you have the patience, you will be rewarded in the end. Why is there 10 in G8? Is it because of the D4 cell? Does F4 change if D4 changes? Let's begin the discussion.
| 24-09-09.xlsx | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| C | D | E | F | G | H | I | J | |||
| 3 | Sale Quarter | Revenue | Rebate | |||||||
| 4 | 1Q'24 | $100 | $10 | |||||||
| 5 | ||||||||||
| 6 | ||||||||||
| 7 | 1Q'24 | 2Q'24 | 3Q'24 | 4Q'24 | 1Q'25 | 2Q'25 | 3Q'25 | 4Q'25 | ||
| 8 | 100 | 10 | ||||||||
Data | ||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C8 | C8 | =IF(C7=C4,D4,0) |
Upvote
0
