G
Guest
Guest
I have a spreadsheet of formula's I need help with, I assume if I figure out even one column's worth of formula, then I can perhaps link them all together to get a successful spreadsheet.
if anyone is available to look at my spreadsheet and give me one on one advice, feel free to email me.
I have columns A thru S -
Each column needs an "IF" type formula.
i.e. Column A is :
<120= +x
121-140= +2x
141-150= +3x
151-170= +4x
171-180= +5x
181-200= +6x
201-220= +12x
221-250= +20x
251+= +40x
other columns are very similar, the end result I HOPE will be pricing in the "t" column. Lets say this is the shipping column. The weight will give the results (IF 171-200 = 6*x) X is a constant throughout the whole spreadsheet, so that with ONE change, the entire price list can be altered.
Perhaps (IF 171-200 = 6*A1) ( I could introduce the value of x in cell A1 and move everything over.
I have some more complicated formula issues later on in the spreadsheet, i.e. if there is text entered in column Q then columns K,L,M,N, are to be ignored.
Any help would be appreciated, how to enter multiple "ifs" to a column of cells (I think perhaps sending the results to sheet 2 of the workbook might be better? ) However seems logical..
ANY ideas would be great.. I'm really at a loss on this. <grin>
if anyone is available to look at my spreadsheet and give me one on one advice, feel free to email me.
I have columns A thru S -
Each column needs an "IF" type formula.
i.e. Column A is :
<120= +x
121-140= +2x
141-150= +3x
151-170= +4x
171-180= +5x
181-200= +6x
201-220= +12x
221-250= +20x
251+= +40x
other columns are very similar, the end result I HOPE will be pricing in the "t" column. Lets say this is the shipping column. The weight will give the results (IF 171-200 = 6*x) X is a constant throughout the whole spreadsheet, so that with ONE change, the entire price list can be altered.
Perhaps (IF 171-200 = 6*A1) ( I could introduce the value of x in cell A1 and move everything over.
I have some more complicated formula issues later on in the spreadsheet, i.e. if there is text entered in column Q then columns K,L,M,N, are to be ignored.
Any help would be appreciated, how to enter multiple "ifs" to a column of cells (I think perhaps sending the results to sheet 2 of the workbook might be better? ) However seems logical..
ANY ideas would be great.. I'm really at a loss on this. <grin>