asked on Embedding the appropriate nested "If" statement
EE Professionals,
I have a quick need for adding an embedded if statement (2nd level). I have attached a graphic that shows what I'm trying to have the formula do.
Thank you in advance,
B.
Nested-If-Statement.png
I have a quick need for adding an embedded if statement (2nd level). I have attached a graphic that shows what I'm trying to have the formula do.
Thank you in advance,
B.
Nested-If-Statement.png
Microsoft Excel
Last Comment
Bright01
ASKER
ssaquibh,
The formula works. However, I have one complication. I have a macro that automatically updates the formula when a change occurs. I get a Compile error that seems to be caused by the word "ONE" in this formula.
Range("R" & Target.Row).FormulaR1C1 = _
"=if(RC[-3]="One Time",RC[-4],if(RC[-4]=0,0
Any ideas on what I'm doing wrong as I try to incorporate the formula in my macro?
B.
The formula works. However, I have one complication. I have a macro that automatically updates the formula when a change occurs. I get a Compile error that seems to be caused by the word "ONE" in this formula.
Range("R" & Target.Row).FormulaR1C1 = _
"=if(RC[-3]="One Time",RC[-4],if(RC[-4]=0,0
Any ideas on what I'm doing wrong as I try to incorporate the formula in my macro?
B.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you ssaqubh! Complicated WS and formula; but your formula and assistance provided the correct answer.
B.
B.
Replace <...> with your previous formula.