formulae

Hi there, I am after some help. What I am wanting to do is to have several formulae in one cell but for the cell to display the results. I don't mean just having a cell which contains several formulae that computes to 1 value. For example, I have a column of yes, no and not applicable answers...

Gday All, Trying to achieve: I have a list of formulae that I need to enter into a particular "Sheet" via VBA. The range is H2:X5000. I have searched far and wide across the internet only to find solutions that do not yeild any results, literally for some reason. Examples of some of the...

Hi All, I am trying to have every 118th cell in a column of one sheet refer to every 9th cell of a column in another sheet. Any way to do this? Thanks, Sam

Dear All I have a macro that populate the spreadsheet for all workingdays of a month, and name them accordingly. I have 2 additional steps which I want Macro to help me with. 1. After populating the spreadsheets, what I need is in the master file, which is the first file of the work, the code...

I need an IF Statement with multiple conditions and my formula is not working: =IF(G12=<100000, IF(G12>200000, IF(G12>300000, 1, 0), 0), 0) where G12 is an actual value. It came with an error. I want: If the total number of the value reached 100,000, add one. Again, in the same cell, if it...

Hello, I would like ask some help regarding the remaining stock calculation. Could somebody offer a formulae into the column C "Remaing stock"?! The sample table can be seen below. The formulae what I use now can be seen below also, but unfortunately does not take into account the deliveries, my...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

Hi All I have a feeling that I'm going to struggle supplying enough good information here, but I'll do my best. It would be excellent if somebody took up this 'project' in general because I'm very much a novice at this and what I'm trying to do is very far out of my depth. Ok, I have a...

Dear Excel Experts- We use SAP system and whenever I copy any data (from SAP) and paste it to excel, it paste it in following format (which is incompatible to sum): 1,468.98 29,463.83 2,281.10- 12,684.40- 64,254.04- So this causes us manually to change it to: 1,468.98 29,463.83...

Hi I had some help earlier off a thread, and just have one more question pls I want to acheive the following: I am using conditional formatting to turn a cell green and want to turn it green under all these conditions: Cell B201 having numbers <!--[if gte mso 9]><xml>...

hi, is there any other way I can make the following equation any shorter please? =AND(OR(B201=3,B201=6,B201=9,B201=12,B201=15,B201=18,B201=21,B201=24,B201=27,B201=30,B201=33,B201=36), OR(B202=3,B202=6,B202=9,B202=12,B202=15,B202=18,B202=21,B202=24,B202=27,B202=30,B202=33,B202=36)...

Hi I have some VBA code that loops through a selection of rows to check for a certain value. The actual rows of data I am looping through are worksheet formulas. Is there any way I can use VBA to read the cells as the results of the formulae instead of the actual formulae itself? I know I...

Hey all I have a whizzy lil spreadsheet which 'draws' a scheduling grid based on the table in the same sheet. Now since the table gets edited manually for changes in scheduling, and new rows and inserted, deleted etc all the time - I've redesigned the drawn grid so that instead of all 15,000...

<TABLE class=MsoNormalTable style="MARGIN: auto auto auto 5.4pt; WIDTH: 477pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt" cellSpacing=0 cellPadding=0 width=636 border=0><TBODY><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 0"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT...

hi i have a IF formulae =IF(K25="Monthly",$B$33,B$34) but what i want is that if there is no value in cell k25 then the result will turn up as ""

I have a database on one sheet and a 2 count if formulae recording information on the next to be exact one formulae counts the number of monthly values and the other count yearly values. I want the sum of these formulaes to be equal or less than 25. and to show an error if the sum of these is...

Hello, I am trying to return the text value of a cell depending on if 2 other criterea are true. Using the example data below I would like to display the status of 'Code'-10.1 from 'Month'-Jan. Example data Sheet1: (Assume Column Headers are A1, B1, C1) Code Month Status 10.3 Jan Checked...