Home Excel

Formulas and Functions

92 Conversations

Latest Activity

Custom List Message Item

Hello,

 

I'm from Switzerland and we speak 3 different languages. Mine is french but the most important is german. I use excel online, the menu is in french, no problem. But when I want to enter a formula, I have to type it in german. That's a problem for m

... Read More
58 Views
9 Replies

Hi Fabrice,

 

You have to change your regional settings (locale) on French. For Excel Online that's actually settings for OneDrive (open it, find Site Settings, when Region

... Read More

Hi,

 

Is the IFS-function working, called WENNS in German, working on Excel 2016 Mac? It works fine on my Win labtop, and also the online version works, but not on my iMac... 

 

Truly yours,

T.

10 Views
0 Reply

Can someone help me resolve an If formula in excel 2010 please?  I have a workbook with multiple worksheets.  I'm trying to copy the cell value that is not blank from one worksheet called Payment Calc to another with my If statement.  My formula in the de

... Read More
18 Views
1 Reply

Hi

 

the formula appears to work fine when I replicate it.

 

When you say the other cells are "blank" can you check by doing

=ISBLANK(B12)

=ISBLANK(B27)

= ISBLANK(D19)

 

They shou

... Read More

I am trying to use CONCATENATE function to add words  from 2 cells together. In one cell, I have words with a character in superscript. The result of the above function give a final words with the superscript character in normal character.

 

Please let me k

... Read More
28 Views
3 Replies

Hi Vinh,

 

Afraid that's only using VBA script

Hi,

 

I need some help.

I'm creating a excel document to help guide user into the correct process to follow.

In my example there are 2 classes (A and B) and  an example budget limit of £10.

My problem is the end result - displaying the reommmended Process (A,

... Read More
58 Views
4 Replies

Thanks

 

The Switch function could help.... however does the Switch formula allow for IF features?

 

Please see attachment, which shares more information.

The objective is to

... Read More

Hi, i want help for formula.

The formula not is TRO*(REP/2) is idem with pic; but no result...

 

ERROR1.jpgERROR2.jpg

Read More
28 Views
1 Reply

can you upload a sample file. you formula looks to be incorrect.

Excel includes 5 formulas to calculate depreciation (SLN,DB,DDB,VDB,SYD) and all of these formulas do not include cells for Starting Date and end date for the cycle to calculate depreciation using it except for VDB formula. For example if we want to calcu

... Read More
965 Views
10 Replies

=IF($A8=1,SLN($A$1,$A$2,$A$3)*((DATEDIF($A$4,$A$5,"ym")+1)/12), IF($A8=$A$3+1, ((12-((DATEDIF($A$4,$A$5,"ym")+1)))/12)*SLN($A$1,$A$2,$A$3),SLN($A$1,$A$2,$A$3)))

----------

... Read More
Nice work
GO on Sir God bless you
Good suggest, I Agree with you Mr.Mohamed

i Agree with you Mr.Mohamed

Hi to everybody.

 

I've just installed Excel for Android and when, in a newly created file

I tried to write a simple "=SUM(B1:B2)" I've got "syntax error" message.

The "=B1+B2" formula works correctly: any help?

 

As I can see all the help on functions is in It

... Read More
34 Views
0 Reply

Hi,

 

I was using advance filter in Excel to select the data with multiple criteria, but i found that it works as "Begins with" not "Equal To"

 

Example:

 

If my Criteria has (1) Abacus (2) Computer (3) Automation (4) se

 

In the Data if i have any entries starrt

... Read More
70 Views
3 Replies

HI Isra,

 

To filter just se, use below text in critera:-

 

="=se"

 

and advance filter option will only filter the exact text "se". 

 

 

Regards,

DILIPandey

Read More

I have a spreadsheet with 3 tabs, "Scorecard" used to pull in data from the other two tabs "Raw Data Tod" and "Raw Data Jim".

 

I have two formuals as per below that work independently of each other, however I want to combine the two formulas into one, so i

... Read More
65 Views
7 Replies
Hi Steven, If you have Excel 2016 or are able to add Power Query in a older version the best option may be to create queries for the data in both tabs and merge them toge... Read More

Hi Steven

Any chance you can load a de-sensitised version of what your doing here?

There may well be a way of simplifying this formula significantly.

 

e.g. this part of the

... Read More

Dear Steven,

 

Try this:

 

=IF(P13="Tod",YOUR FIRST FORMULA,
IF(P13="Jim",YOUR SECOND FORMULA,
""))

Hi Steven,

 

Try exploring Indirect function which you can use here.

As you already know about complex formula, you can easily customize it to suit your need.  thanks.

 

 

Rega

... Read More

Worksheets("REPORTS").Range("S22").Formula = "=+'18 hole scores'!RC" & DateColumn

.

I have had this formula for 4 years and it worked fine. It puts a vaue like C27 into cell S22.

I have not made any changes to the macro.

Now, the result in S22 is literally RC

... Read More
36 Views
2 Replies

Hi George,

 

I guess it is related with R1C1 reference style.

Follow below path in your excel window

Excel Options -> Formulas -> Working with Formulas -> R1C1 reference styl

... Read More

Hi George,  are you able to attach your file or some screenshots?

 

Thanks

Hello All

 

I have a quick question.

 

I want to categorize my data in three categories like Good Average and Bad, the whole sheet consists of different groups. Below is the example of data, the file is attached as well.

 

S/NGroupsAmountCategory Scale for Grou
... Read More
55 Views
4 Replies

Hello Muhammad

 

Restrcuture your scale tables into one table.

 

Group - Lower - Category

A - 0 - Bad

A - 12 - Good

A - 16 - Average

A - 21 - Bad

etc.

 

In my example the new table

... Read More
Best Response

I have a spreadsheet with 3 tabs, "Scorecard" used to pull in data from the other two tabs "Raw Data Tod" and "Raw Data Jim".

 

I have two formuals as per below that work independently of each other, however I want to combine the two formulas into one, so i

... Read More
16 Views
0 Reply

I need to combine a bit of text, followed by a formula in a single cell.  For example, I  have a multi-worksheet spreadsheet that uses data from page 1 to fill in the same data on pages 2 & 3; part numbers, customer name and the like.

I want a single cell

... Read More
48 Views
2 Replies

Hi @chrisp

 

="Revision "&'SETUP-1'!R4

Read More

Hi all,

 

I am trying to get rid of some legacy formulas in one of my Excel table. When trying to remove the content in the table or pasting everything as values, I can still find the XML tag <calculatedColumnFormula> with the old formula in the XML for som

... Read More
58 Views
2 Replies

Hi Edouard,

 

When you create a formula in a Table then it gets stored in that column.  I like to think of it as being "stored" in the column header.

 

That way even when you

... Read More

Hi Edouard,

 

Interesting question. IMHO, as soon as calculatedColumnFormula tag appeared in Table.xml you can't remove it within UI.

 

Tag appears if you enter the formula i

... Read More