fill down with conditions - can it be done?

[amyfb]

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?

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.

 

[asjones987]

I would just do an Add Conditional column with all your option in one if statement. The conditional column GUI may be all you need without editing the raw M code. This link should be good.

https://gorilla.bi/power-query/if-function-in-power-query/