Encapsulating multiple Formulae

[racingsnake2000]

Hello again.. (this site is habit forming!)

Can anyone tell me if it possible (I'm sure it must be...) to save say 52 adjacent formulae in such a manner so as you can past all of those into one big formula to add additional filtering capabilities to a spreadsheet?

For Example:
Lets say I wanted to put an entire range of cells with their own independent(although similar) formulae into an "IF" formula...

 

[Gerald Higgins]

Suppose, instead of 52 formulas, you had - let's say - 3.

What would you want it to look like ?
Can you give us the 3 individual formulas, and what you want them to do once they are combined ?

 

[racingsnake2000]

Hi.
The series of formulae of the 26 adjacent pairs of cells is below:

CV1178=IF($AT1178="d-in",IF($AM1178=(CV$5),($AS1178),""))
CW1178=IF($AD1178="CARBON STEEL",(CW$5),IF($AD1178="LOW-ALY STL",(CW$5*$CW$3),IF($AD1178="DUPLEX S. STEEL",(CW$5*$DA$3),IF($AD1178="STNLS STEEL",(CW$5*$CY$3)))))
CX1178=IF($AT1178="d-in",IF($AM1178=(CX$5),($AS1178),""))
CY1178=IF($AD1178="CARBON STEEL",(CY$5),IF($AD1178="LOW-ALY STL",(CY$5*$CW$3),IF($AD1178="DUPLEX S. STEEL",(CY$5*$DA$3),IF($AD1178="STNLS STEEL",(CY$5*$CY$3)))))

What I'd like to achieve is have multiple instructions of say 3 or 4 different formulae which encapsulate the above(all 52 columns) and variances of them such that depending on the contents of a seperate column, a different set of these formulae will apply?
It's a bit difficult to explain properly without knowing the correct terminoligy so I hope you understand?

 

[Gerald Higgins]

...I hope you understand?

Nope, sorry !

Which are the 26 adjacent pairs of cells ?

 

[racingsnake2000]

Hello Gerald,
The 52 columns of cells would be from AS to CR.
I only showed four to represent the formulae input into the individual cells.
basically, I was hoping to say (in laymans terms):
if the contents of a particular column's cell said "this", then apply these formulae to this range of cells;
if the contents of a particular column's cell said "that", then apply this different set of formulae to the same range....
I have 6848 rows of information to filter and sort...
Quite useful I'd have thought based on the fact that I'm working with multiple material grades and multiple different sizes which obviously means different factors and procedures need to be applied.

Thanks for your time anyways.... I'm sure I can come up with a few more challenginging questions!

 

[Gerald Higgins]

I think I know roughly what you want but I'm still struggling to understand exactly what you want.

The formula in CW1178. . .

You COULD modify this so it contained a lookup formula.

Set up a lookup table like this, let's say it's in the range A1:B

Col A.................Col B
Carbon Steel.......1
Low-Aly Steel......(whatever the value is in CW3)
Duplex S Steel.....(whatever the value is in DA3)
and so on.

Then, in CW1178, something like

=CW5*(vlookup(AD1178,A1:Bn,2,false))

Does this make sense ?