Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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

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.

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?

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.

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.

Related Topics:

- Any idea how to write formula?
- help needed for logic building
- Paste Formula help
- formula help but not vba please
- Please Help on IF AND OR logic
- Please Help me in this Formula
- HTC code writing..(Any one out here?)
- write data from one workbook to another
- Is there anyone to help me for problem given below
- Help in writing a function
- About using UTF-8 charset in JSP pages in Web logic
- Logic error
- BEA Web Logic
- J2EE logic test solution - JTracker
- VBA Formula prob
- Getting a formula to copy from inside VBA
- Populate Formula(Function) in rows
- searching within formulas
- Formula using range name in VBA code
- Three Leveled Formula
- R1C1 Formula
- VBA or array formula?
- VBA code to add values in two cells which have formulas
- combining formula
- Array Logic