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
- Help in writing a function
- Array Formula
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- Stuck on copying formula from 1 sheet to another
- Named formula/Windows dialog boxes
- cells containing formula that refer to user-defined VBA function
- sum formula
- Manually creating a row outline with no formula anywhere
- Blank Formula bar
- Using Boolean logic instead of IF, AND, OR functions
- 2003 - Moving to a formula address
- Disabling Formulas, Not calculation
- Quotations in Formulas and strings
- Copy Value produced by formula in cell C3 to cell D3
- formula returns to multiple cells, without Array object?
- Formula with conditional text