|
This is an Excel formula with nested IF statements:
=IF((B2="East"),4,IF((B2="West"),3,IF((B2="North"),2,IF((B2="South"),1,""))))
To essentially accomplish this:
If cell B2 = "East" return "4" ElseIf cell B2 = "West" return "3" ElseIf cell B2 = "North...
Started by Jeremy Rudd on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Excel's formula bar ignores line feeds and white space, so you can Alt+Enter spacebar-ing, especially....
Could put:
=DirectionAsInt(B2)
Excel Formula Formatter add-in by Rob van Gelder, mentioned at Daily Dose of Excel.
|
|
Hello, I’m not an Excel or VBA expert but I want to insert this current excel formula into cell’s using VBA.
Current Excel formula:
=IF(OR(ISNUM(D570)=FALSE;ISNUM(D573)=FALSE);"";IF(C573="Total";D573-D570;""))
VBA formula :
ActiveSheet.Range("a" & ActiveSheet...
Started by geek1983 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Using the .formula property, you....
In this case, your formula is simply converted to a string value.
Setting the .value of a cell simply copies in whatever value you specify .
Try using .formula = instead of .value = in your VBA code.
|
|
Hi everyone,
Just wondering if anyone on here is an excel guru and would be able to to help me out with creating a formula that I need because I am a noob with advanced excel formulas.
Started by Bhugz on
, 15 posts
by 8 people.
Answer Snippets (Read the full thread at geekzone):
You best post what you need....
Bhugz: Hi everyone,
Just wondering if anyone on here is an excel guru and would be able to to help me out with creating a formula that I need because I am a noob with advanced excel formulas.
|
Ask your Facebook Friends
|
A field in excel contains words seperated by semicolons
e.g
A1 = save;the;national;treasure;for;good
how can i apply excel text formula to produce seperate words from this field in another field
e.g
a2 should conatain a formula to result the first word...
Started by silverkid on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
- 1) Else ExtractElement = "" End If End Function
Then the A2 formula would be: =ExtractElement(A1, 1 your text to parse in A1 then the following formulas should work
In A2 enter the formula
=IF(ISERROR(LEFT(A1,FIND(";",A1)-1)),A....
|
|
I have Excel sheet with 5000 rows and columns till AY (size 12MB). Except for the first 6 columns, rest contain either vlookups or formulae. All the vlookups are in separate Excel sheet. I have changed the Excel setting to manually update the links and...
Answer Snippets (Read the full thread at superuser):
Beyond the pre-opening and sorting help, I'd suggest taking a look at the non-lookup formulae: can functions are called and how much ....
Maybe get a faster computer or upgrade your RAM
Unfortunately, that's the way it is with Excel.
|
|
I'm nedding to implement excel formula autofill in C#.
Let's suppose this formula is located at B100:
=SUM($B$99:B99)
I want to make this formula different at C100:
=SUM($B$99:C99)
This formula is only an example. Some real examples are:
=(SUM($B${0}:...
Started by Victor Rodrigues on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Maybe once you digest all the rules for tokenizing a formula, you'llYou're sure you're not making this too complicated, right? This is something Excel does natively into Excel's....
Develops/2004/12/excel_formula_p.html .
|
|
I have a situation where i need to put a formula in the "Value_if_true" and "Value_if_false" fields in an IF function but it does not seems to be working. It just keeps displaying my formula as is in the cell. Can someone help?
Started by Garima Kumar on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Just....
You can put a formula in another cell and point the if statement to that cell for the result like so:
A1 =IF(B1, IF(B2, B3, B4), B5)
As you've now provided the formula, i'll fix it:
=IF(I5=0,(12-BC5)*BE5 + BH5,BF5)
should work
Um...
|
|
Hello,
I have many cells where data is broken up into many lines; some of those lines are blank. Is there a VB function or formula to remove blank line breaks in Excel cells, or all line breaks?
Many thanks!
Started by Mel on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
), "")
There is a detailed tutorial on the subject called Excel VBA: How To Delete Rows , by Colin Legg that should cover all.
|
|
Hi there,
I have some code that those:
void mActiveSheet_Change(Microsoft.Office.Interop.Excel.Range Target) { if (Target.Cells.Formula.ToString().StartsWith("=FR(")) .... }
So whenever someone uses my custom function "=FR" I can handle it.
That's fine...
Started by Billy on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Might be help you out; The goal is to create your own function which....
Probably you should read this post.
That is the Excel error code that is displayed when a function it was before so the answer can be seen.
You are correct about #NAME?.
|
|
I have the following worksheet #1 (simplified for the question) of person and age: Person Age Bob 40 Brett 35 Brian 38
I would like to setup another worksheet where I have the following: Person Age Spot #1 FORMULA
The user will enter a name in Spot #1...
Started by NoahD on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Although I would recommend that you make your data table a Named Range and reference it using VLOOKUP(A2, MyDataTable, 2)
Person Age... .
This example below assumes that your data table is in Sheet1!A1:B4 .
Try the vLookup function
Use the VLOOKUP function.
|
