Search:

# Can Any one help me writing logic for the given formula

Asked By: Lucas    Date: Jan 07    Category: MS Office    Views: 3003

These formulas, paste it horizontally and then see how does the formulas flow
rows.

=IF(J11<=0,"",IF(E11<=0,"",(J11/E11-1)))

=IF(K11<=0,"",IF(F11<=0,"",(K11/F11-1)))

=IF(L11<=0,"",IF(G11<=0,"",(L11/G11-1)))

=IF(M11<=0,"",IF(H11<=0,"",(M11/H11-1)))

=IF(N11<=0,"",IF(I11<=0,"",(N11/I11-1)))

=IF(O11<=0,"",IF(J11<=0,"",(O11/J11-1)))

=IF(P11<=0,"",IF(K11<=0,"",(P11/K11-1)))

=IF(Q11<=0,"",IF(L11<=0,"",(Q11/L11-1)))

=IF(R11<=0,"",IF(M11<=0,"",(R11/M11-1)))

=IF(S11<=0,"",IF(N11<=0,"",(S11/N11-1)))

=IF(T11<=0,"",IF(O11<=0,"",(T11/O11-1)))

=IF(U11<=0,"",IF(P11<=0,"",(U11/P11-1)))

=IF(V11<=0,"",IF(Q11<=0,"",(V11/Q11-1)))

=IF(W11<=0,"",IF(R11<=0,"",(W11/R11-1)))

=IF(X11<=0,"",IF(S11<=0,"",(X11/S11-1)))

=IF(Y11<=0,"",IF(T11<=0,"",(Y11/T11-1)))

=IF(Z11<=0,"",IF(\$U11<=0,"",(Z11/\$U11-1)))

=IF(AA11<=0,"",IF(\$U11<=0,"",(AA11/\$U11-1)))

=IF(AB11<=0,"",IF(\$U11<=0,"",(AB11/\$U11-1)))

=IF(AC11<=0,"",IF(\$U11<=0,"",(AC11/\$U11-1)))

=IF(AE11<=0,"",IF(\$U11<=0,"",(AE11/\$U11-1)))

=IF(AF11<=0,"",IF(\$U11<=0,"",(AF11/\$U11-1)))

=IF(AG11<=0,"",IF(\$U11<=0,"",(AG11/\$U11-1)))

=IF(AH11<=0,"",IF(\$U11<=0,"",(AH11/\$U11-1)))

=IF(AI11<=0,"",IF(\$U11<=0,"",(AI11/\$U11-1)))

=IF(AI13="","",IF(Z13="","",(AI13-Z13)))

=IF(AL11<=0,"",IF(\$V11<=0,"",(AL11/\$V11-1)))

=IF(AM11<=0,"",IF(\$V11<=0,"",(AM11/\$V11-1)))

=IF(AN11<=0,"",IF(\$V11<=0,"",(AN11/\$V11-1)))

=IF(AO11<=0,"",IF(\$V11<=0,"",(AO11/\$V11-1)))

=IF(AP11<=0,"",IF(\$V11<=0,"",(AP11/\$V11-1)))

=IF(AQ11<=0,"",IF(\$V11<=0,"",(AQ11/\$V11-1)))

=IF(AR11<=0,"",IF(\$V11<=0,"",(AR11/\$V11-1)))

=IF(AS11<=0,"",IF(\$V11<=0,"",(AS11/\$V11-1)))

=IF(AT11<=0,"",IF(\$V11<=0,"",(AT11/\$V11-1)))

=IF(AU11<=0,"",IF(\$W11<=0,"",(AU11/\$W11-1)))

=IF(AV11<=0,"",IF(\$W11<=0,"",(AV11/\$W11-1)))

=IF(AW11<=0,"",IF(\$W11<=0,"",(AW11/\$W11-1)))

=IF(AX11<=0,"",IF(\$W11<=0,"",(AX11/\$W11-1)))

=IF(AY11<=0,"",IF(\$W11<=0,"",(AY11/\$W11-1)))

=IF(AZ11<=0,"",IF(\$W11<=0,"",(AZ11/\$W11-1)))

=IF(BA11<=0,"",IF(\$W11<=0,"",(BA11/\$W11-1)))

=IF(BB11<=0,"",IF(\$W11<=0,"",(BB11/\$W11-1)))

=IF(BC11<=0,"",IF(\$W11<=0,"",(BC11/\$W11-1)))

=IF(BD11<=0,"",IF(\$X11<=0,"",(BD11/\$X11-1)))

=IF(BE11<=0,"",IF(\$X11<=0,"",(BE11/\$X11-1)))

=IF(BF11<=0,"",IF(\$X11<=0,"",(BF11/\$X11-1)))

=IF(BG11<=0,"",IF(\$X11<=0,"",(BG11/\$X11-1)))

=IF(BH11<=0,"",IF(\$X11<=0,"",(BH11/\$X11-1)))

=IF(BI11<=0,"",IF(\$X11<=0,"",(BI11/\$X11-1)))

=IF(BJ11<=0,"",IF(\$X11<=0,"",(BJ11/\$X11-1)))

=IF(BK11<=0,"",IF(\$X11<=0,"",(BK11/\$X11-1)))

=IF(BL11<=0,"",IF(\$X11<=0,"",(BL11/\$X11-1)))

=IF(BM11<=0,"",IF(BD11<=0,"",(BM11/BD11-1)))

=IF(BN11<=0,"",IF(BE11<=0,"",(BN11/BE11-1)))

=IF(BO11<=0,"",IF(BF11<=0,"",(BO11/BF11-1)))

=IF(BP11<=0,"",IF(BG11<=0,"",(BP11/BG11-1)))

=IF(BQ11<=0,"",IF(BH11<=0,"",(BQ11/BH11-1)))

=IF(BR11<=0,"",IF(BI11<=0,"",(BR11/BI11-1)))

=IF(BS11<=0,"",IF(BJ11<=0,"",(BS11/BJ11-1)))

=IF(BT11<=0,"",IF(BK11<=0,"",(BT11/BK11-1)))

=IF(BU11<=0,"",IF(BL11<=0,"",(BU11/BL11-1)))

=IF(BV11<=0,"",IF(BM11<=0,"",(BV11/BM11-1)))

=IF(BW11<=0,"",IF(BN11<=0,"",(BW11/BN11-1)))

=IF(BX11<=0,"",IF(BO11<=0,"",(BX11/BO11-1)))

=IF(BY11<=0,"",IF(BP11<=0,"",(BY11/BP11-1)))

=IF(BZ11<=0,"",IF(BQ11<=0,"",(BZ11/BQ11-1)))

=IF(CA11<=0,"",IF(BR11<=0,"",(CA11/BR11-1)))

=IF(CB11<=0,"",IF(BS11<=0,"",(CB11/BS11-1)))

=IF(CC11<=0,"",IF(BT11<=0,"",(CC11/BT11-1)))

=IF(CD11<=0,"",IF(BU11<=0,"",(CD11/BU11-1)))

=IF(CE11<=0,"",IF(BV11<=0,"",(CE11/BV11-1)))

=IF(CF11<=0,"",IF(BW11<=0,"",(CF11/BW11-1)))

=IF(CG11<=0,"",IF(BX11<=0,"",(CG11/BX11-1)))

=IF(CH11<=0,"",IF(BY11<=0,"",(CH11/BY11-1)))

=IF(CI11<=0,"",IF(BZ11<=0,"",(CI11/BZ11-1)))

=IF(CJ11<=0,"",IF(CA11<=0,"",(CJ11/CA11-1)))

=IF(CK11<=0,"",IF(CB11<=0,"",(CK11/CB11-1)))

=IF(CL11<=0,"",IF(CC11<=0,"",(CL11/CC11-1)))

=IF(CM11<=0,"",IF(CD11<=0,"",(CM11/CD11-1)))

I want to calculate the percentage of the data line item two row above this line
when pasted in a row.
but it has three distinct feature

Share:

Just put the first formula  in the first column and then use the fill handle to
drag it across to the subsequent columns. It will change automatically.

Just copy the formula  text and paste  it with transpose form and you will u'stand
the problem.

And I wan solution in the VBA coding form ie in Macro coded form.

I'm afraid your formulas  don't mean much.
Nor what you want help  with.

Are you saying that you want to automatically  insert these formulas
into a row  two rows below where you put data?
Plus, I'm not sure what you're asking about percentages. (that's not what the
formula is)
and, what is "three distinct features"?

I guess it would help to see the spreadsheet.

OK. The file has been posted. Now your original query was

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
These formulas, paste  it horizontally and then see how does the formulas  flow
Please help  me in this regards to automatically  generate it for the multiple
rows.

=IF(J11<=0,"",IF(E11<=0,"",(J11/E11-1)))

=IF(K11<=0,"",IF(F11<=0,"",(K11/F11-1)))

=IF(L11<=0,"",IF(G11<=0,"",(L11/G11-1)))

... etc.
++++++++++++++++++++++++++++++++++++++++ end of quote

I cannot understand what you want or where it relates to the file.

Which cell do you want the formula  =IF(J11<=0,"",IF(E11<=0,"",(J11/E11-1)))
in?

Why do you want to generate  these formulas with VBA rather than putting them
in the spreadsheet in the design stage?

What has pasting horizontally got to do with it?

which arise because you are trying to do something irrelevant or impossible.
Tell me what the end result is supposed to be.

I want to automate the %Change YoY row.
I want macro which when run will calculate  the % Change YoY automatically.
Can you help  me in this regard?

I do not understand. if the cells in row  25 on the summary sheet contain the
relevant formula  what would the VBA do?

Didn't find what you were looking for? Find more on Can Any one help me writing logic for the given formula Or get search suggestion and latest updates.