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?
- Please Help on IF AND OR logic
- Please Help me in this Formula
- help needed for logic building
- Paste Formula help
- formula help but not vba please
- write data from one workbook to another
- HTC code writing..(Any one out here?)
- Is there anyone to help me for problem given below
- writing assembly code using 2 procedure and one macro to sort array of names
- Automatically apply specific formulas to specific columns
- Design Logic
- Romberg's intigration formula.
- VBA Code for pasting a set of formulas down a data range
- VBA variable range in a formula
- copy down formulas in excel
- Formula multiplying ActiveCell with "F11"
- About using UTF-8 charset in JSP pages in Web logic
- Logic error
- BEA Web Logic
- J2EE logic test solution - JTracker
- Array Formula
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- Help in writing a function
- Stuck on copying formula from 1 sheet to another