amyfb
New member
- Joined
- Dec 18, 2020
- Messages
- 24
- Reaction score
- 0
- Points
- 1
- Location
- Southeastern PA, USA
- Excel Version(s)
- O365
I am using Office365 Excel,
in this chart, the blank rows need to be populated with a value that is calculated from the number preceding the blanks. THe value of each blank row is conditional on the value in another column, and the if/then would apply a different discount depending on the conditional value.
Can I write one formula that does this?
I don't want to write a formula for each section of blank rows; i'm already dealing with that nightmare.
I can write the formula to go horizontally, with added columns, but for our purposes, the data needs to go vertical.
can anyone help me achieve a lean formula approach to this?
thank you for looking and all ideas welcome.
in this chart, the blank rows need to be populated with a value that is calculated from the number preceding the blanks. THe value of each blank row is conditional on the value in another column, and the if/then would apply a different discount depending on the conditional value.
Can I write one formula that does this?
I don't want to write a formula for each section of blank rows; i'm already dealing with that nightmare.
I can write the formula to go horizontally, with added columns, but for our purposes, the data needs to go vertical.
can anyone help me achieve a lean formula approach to this?
| data | condition | formula |
| 31.755 | 1 | if (condition = 1, data, "") |
| 2 | if (condition = 2, data from condition 1 * .97, "") | |
| 6 | if ( condition = 6, data from condition 2 * 97, "") | |
| 11 | if (condition = 11, data from condition 6 * .97,"") | |
| if (condition = "", "", "") | ||
| 1.629 | 1 | |
| 2 | ||
| 6 | ||
| 11 | ||
| 6.57 | 1 | |
| 2 | ||
| 6 | ||
| 11 | ||
| 8.8872 | 1 | |
| 2 | ||
| 6 | ||
| 11 |
thank you for looking and all ideas welcome.