Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Can Any one help me writing logic for the given formula

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

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)))


=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(AD11<=0,"",IF($U11<=0,"",(AD11/$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: 

 

6 Answers Found

 
Answer #1    Answered By: Jonathan Brown     Answered On: Jan 07

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.

 
Answer #2    Answered By: Zobebah Mizrachi     Answered On: Jan 07

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.

 
Answer #3    Answered By: Chuong Tran     Answered On: Jan 07

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.

 
Answer #4    Answered By: Indie Williams     Answered On: Jan 07

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?

I would rather help you achieve your objective than help you solve problems
which arise because you are trying to do something irrelevant or impossible.
Tell me what the end result is supposed to be.

 
Answer #5    Answered By: Kuhlbert Schmidt     Answered On: Jan 07

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

 
Answer #6    Answered By: Maria Hughes     Answered On: Jan 07

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.




Tagged: