Search results

=IF(E1="C purchased" to =IF(E11Like"C purchased" How to change?

=IF(EXACT(A2,UPPER(A2)),"Upper Case",IF(EXACT(A2,LOWER(A2)),"Lower Case","Upper and Lower Case")) Now I get Upper Case when cell is empty.

See example I am looking for a formula that calculates the cost under 15.000 km at 0.018 and the difference above the 15.000 at 0.022 and make a total

See example

I have a result in a cell formated as uu:mm, for example 3:00, Then I need to add 3 times 10 minutes in another cell result should be 3:30 in a another cell. If the first cell is 2:30 then the result should be 2:55 (2 times 10 minutes and 1 time 5 minutes) The goal is when somebody works on a...

=IF(WEEKDAY(TODAY(),2)=6,TODAY()-1) IF(WEEKDAY(TODAY(),2)=7,TODAY()-2) I want to combine these 2 so that if it is weekend cell always returns last friday

Hi, I have this code to empty junkfolders in outlook. Unfortunately, it only works for the default account, what can I do to let it work for both accounts? Thanks. Sub EmptyDeletedItems() Dim olApp As Outlook.Application Dim olNS As Outlook.NameSpace Dim objExpl As Outlook.Explorer Dim mboxCount...

How can i change this code so it works for jpg and gif? If Dir(Path & Cell & ".jpg") <> "" Then With .Pictures.Insert(Path & Cell & ".jpg") Thanks in advance

When I fill date paid on in sheet 2 column B iwant to fill column I on sheet1 automatically with the dates. See example. Thanks in advance.

if the character is è or ì I would like these two characters change to windings. this in cells with more text ,the rest of the text should remain Arial

I have an excel query, but I only want the rows where the value in column 5 is less then the value in column 6 How can I set that criteria? Thanks.

I have 3 tables with different locations. With the names of the people that belong to these locations. In another table I want the locations next to the names See example

What would be the formula for: if column A range contains apples and pears then count column c that contains cancelled or pending Thanks in advance

I have this formula. =INDIRECT("Sheet" & COLUMN()-COLUMN($C$1)+1 & "!$A$1") But instead of the value I want the cell address. Thanks in advance

Hi, I am looking for code to solve my problem in attached example. I put the explanation in the file. Please advice Thanks in advance.

I have this formula: =IF(LEN(A1)=1,TEXT(A1,"0"),TEXT(A1,"0.00")) in CF How do I add the thousand separator. 4000 should be 4.000 10000 should be 10.000 4000,25 should be 4.000,25 10000,60 should 10.000,60 and if possible 10000,50 should be 10.000,50, not 10.000,5 Thanks in advance It can be a...

When i enter 1234567899, i want the cell changes automaticly into 12-34.-5678.-9\9 formula, vba Cell Properties, every solution is ok. thanks

I want to fill cell b2 with the text yes when Cell A2 is not empty, formula in cell A2 thanks to help.

How to combine list (range) and =NOT(ISBLANK(A1)) in datavalidation thanks

See example

I am looking for a formula when the values in Colum c and column b and column c are the same, i want to count the differences in column D result in E A B C D E (result of formula) ok bread butter Cheese 2 ok bread butter meat 2 ok...

I have a slicer on a sheet, I would like to clear A1:B10 when Slicer filter is cleared. (nothing selected)

I am new to excel. See question in attachement. Thank you for helping.

I have Textbox1.Value = Format(Date, "dd/mm/yyyy") and Textbox2.Value = Format(DatePart("q", Textbox1.Value)) The result in textbox 2 is wrong, it uses the American date notation example 02/05/2019 gives as result 1(uses 02 as month) but it should be 2 (5th month, second quarter) How can I...

I have Set Rng = [ANRs] Set fnd = Rng.Find(What:=T_26.Value, LookIn:=xlValues, LookAt:=xlWhole) If Not fnd Is Nothing Then smessage = "Afrekenen, ben je zeker" + "?" If MsgBox(smessage, vbQuestion + vbYesNo, "Bevestig Afrekenen") = vbNo Then GoTo oops ws.Rows(fnd.Row).ClearContents I want to...