# Archive by month July

## Formula for IF solutions

I am wondering how I can set up a formula to calculate the dollar amount earned per rep based on the individual GA sales when the Store total hits a tier. I …

## Time Range to output break

What i would like to say is  If D4>3:30>6:00 then insert 10 but if D4>6:00>10:00 then insert 20 but if D4>10:00>14:00 then insert …

## Help With Visual Basic Program For Excel

I am having trouble designing a program with VBA for Microsoft Excel. I have one column of a list with company’s that are labeled “long …

## Mangosteen Slim Сироп Для Снижения Веса, Мангустин Слим

Предлагаем нашим покупателям удивительное средство для похудения сироп Мангустина. С …

## randbetween()

Good afternoon,   I am trying to create a randbetween formula. I have a schedule for the waiters for 7 days. Monday 4 server AM and 6 server PM | 4 …

## sorting alphabetically in excel

Hello! In Ms Excel, sorting a list alphabetically in English is OK but is this facility available if the list is in a language other than English(e. g. Nepali/ …

## Autofill cell

Hello, So, I have an excel scheet. When i type a word in any cell of the table, i want to automatically appear in the next cell, a predefined word. For …

## Student

I have a data spreadsheet that has student’s marks in it. I should check for each one, if they scored less than 40 in any subject, the result should say …

## Formula question not to exceed

Need help on how to write a formula. In box F3 I want to write C3x3% but to be equal to or less than D3   By: John

## Accountant

Hi I am working on an Excel 2007 workbook within which there are 9 worksheets. In particular, there is 1 worksheet which is giving me trouble. There is a row …

121385  Police 121387  people 121577 Men 138834  boy 50120081 girl 165105 women   is there any method to find the value and put in …

## 1st name and 2nd name mixed up

Hi,   I have a problem to which I can’t find answer anywhere. I have a long list of costs with employee names. The problem is that the names in the …

## Mangosteen Средство Для Похудения, Мангустин

Хотим предложить вам удивительное средство для снижения веса Mangoosteen. С его помощью …

## Pivot Table Graph Filter

Hi there all!   I’ve made a dashboard with some data and I’ve made it so its interactive.  You can click on filter options and all the …

## What the LEN function

When I am using Excel16 or Excel 16 for Mac. I have 3 columns        A B C 1  first name last name password 2 John Smith …

## Multiple Columns, WHATIF

I need a formula that can highlight rows once certain criteria is met. Example below would be If Colum “R” is filled in for all of the same numer …

## Reference to Sheet name/Page number

Is there a forumla that will pull the sheet name and page number of a referenced cell? For instance, in the numbers above the value 70,271.25 is coming from …

## using % in conditional formatting

The question is: The person passes the test if the total is at least 50% OR the person participates in funding( noted as “yes”) When I type the …

## counting of data in excel

This is my data     1   apple   mango     2   peach   coconut   grapes   3 peach apple   4 peach mango …

## Macro: Copy, Insert, Paste and Clear the Merged Cells from the previous row.

I am trying to write a Macro that will do the following. From an existing Worksheet not Table Copy a row with merged columns Insert the row below it (down) …

## Excel Fuction

I need an excel function that will add up to 150 to another cell the total not to exceed 750.00 By:

## If/and statements

I’m trying to write a statement to say;   If the cell in B1 is greater than 10,000, return Check.  If the cell in B1, is between 1,000-10,000 …

## Dogs Body

Hi Im trying to format a cell with nested IF conditions that will instantiate a mail. I have columns including surname, firstname, DOB, Grade and a drop list. …

## Cash Flow simulations

Hi,   Im simulating business cash flows out 13 months, and primarily I am looking to model the cash flow impliactions between creidt grnated by suppliers …

## Working the percentage of complete checks into a formula and then into a bar graph

Hi all, I have been playing around with a few check lists that we hold within the maintenance team. One such is the checking of emergency exit lighting …

## Мебель каталог

http://bigwork.info/ Набор мебели в спальню состоит обычно из кровати, тумбочки к ней, шкафа, …

## Split data by specific colmuns

Hi,   I am looking to get the way to split the excel file with colmuns. For example , I want A and B columns in everysheet but want C and D in 1 sheet …

## Decimal Places changed

I was working on a report and saved an excel file last Friday. However, when I re-opened it the decimal places of the figures I entered suddenly changed. Help! …

## Help with pivot table from multiple sheets

I am new to pivot tables, and would like some help please. I have a sheet with new contracts in ie. sales sold by each salesman. Date in first column then …

## excel headline like in word

Hi, so i’m excel noob and need help.   i’m trying to make excel where by clicking Headline A i could hide the rows below? Headline A …

## Curtis

In Cell A1 I type 5 In Cell A2 I type 3 I want the summed value in Cell A3 to show =5+3 in the display box, not =A1+A2. Of course, in the worksheet cell A3 …

## Mangosteen Состав И Свойства, Отзывы, Купить

Приобрести сироп Mangoosteen можно на веб-сайте http://mangjoo77.mangoosteen.com Хотим предложить вам …

## мазь против грибка ногтей

Перейти на сайт: http://tinedol.bxox.info/ Тинедол – эффективное средство от грибка стопы, …

## triple quotes in csv

when excel data is converted into csv, all the doble quotes changes into triple quotes. how to solve this? ex- “text” in excel …

## EXCEL FUNCTION

I have been thinking of combining if and vlookup functions to help me find and look for values as follows: …

## Excel Coding

I am using excel 2016. I recently started a new job at a property management company. The person that had the job before me created an excel sheet to track a …