# How to create a formula in excel 2016 jobs

Need **a** **formula** for Intraday, BTST and cash segment share price **formula**

...PRINTING TAB
Whenever you select **a** SCREEN on Cell F3-7, it will populate with that amount **in** Cell I17.
But will say (THE NUMBER) Setup or Setups
Like this:
Price Includes: 1 Front Colour, 1 Setup, Screen Printing
If it's 2 or more it changes **to**:
Price Includes: 2 Front Colours, 2 Setups, Screen Printing.
when you select **a** colour it puts on Cell I17 XXX

I have an **excel** sheet I need the **formula** and/or macro edited for.

I need **to** have **a** spreadsheet I have created, automatically change colours when inspections are due, and servicing duration selectable by **a** drop down cell.

I need **to** delete some data **in** the database of my software written **in** Java and hosted on Tomcat.
i made some error **in** entry so i need **to** delete the data and make my entry again.
i also need **to** copy out **a** **formula** from one of the files.

...looking for some **to** **create** **a** **formula** that would be able **to** transform **a** distance **in** yards and feet **to** **a** primoximty **to** **a** random position **in** yards
Column **a**,b and c would be manually imputted
The data **in** Column **A** would be **a** distance **in** yards
Column B would would be the distanc...

**create** **a** VBA function that plays 100 rounds of the game friend or foe

Hi I need the following **formula**.
We use Google sheets for tracking projects. We need **to** be able **to** know when we have assigend **a** person too many tasks for them **to** complete **in** one day. So if we assign them too many hours, something goes red **to** highlight it.
Here is **a** sample spreadsheet: [login to view URL]

**Create** an **excel** spreadsheet "program" **to** reformat data from various cells **in** one sheet **to** another. Combine cell data based on other cell data.

Make **a** spreadsheet for the transport system and integrate automate system for the data update and Generate Reports.

Hey! I need **a** formular **in** Row J:
IF Row B = (is found **in**) Sheet "Kosten" Row B
AND IF Row F = (is found **in**) Sheet "Kosten" Row G
THEN SHOW Price of Sheet "Kosten" Row R
File is attached. I think it's very easy for you. Who can help?

Hi there,
i have **a** set **a** data **in** **excel**, i need someone **to** **create** some advanced pivot table with **formula**, and **a** couple of graphs.

This is **a** simple project for **a** Mathematician **to** work out **a** **formula**. See the attached image please.

I am trying **to** convert and **excel** **formula** into php but the results are not the same

I need **to** explain what the **formula** describes **in** PM (Removed by Freelancer.com Admin)
It's **a** simple, fun project I am working on. I will need 1, max 2 hours of your time.
I can pay $10 per hour

...columns **in** **excel** with core data and three columns with input fields, when user puts value **in** the input fields it need **to** check if it is according **to** the core data (value is on same row)
If not is the same, it needs **to** show message box stating, value is not the same.
then user can proceed **to** change value or keep different value
and it has **to<**...

I am soon releasing **a** music video of my song The Peace **Formula** ([login to view URL])
I want it **to** go viral on the internet and I want **to** hire who knows **how** **to** make it go viral.

Column D contains **a** code. The first 8 digits of the code have many duplicates, with only the last 3 digits (including the -) being different.
I want **to** hide, or remove, all rows that have duplicates on the first 8 digits.
Quick and easy.

I have two lists. List 1 has last and first names **in** the same columns, plus other columns containing other values. List 2 has column **A** Last Name and column B First Name only. I need **to** find duplicate first and last names and remove the entire row of duplicates from both lists.
The first list contains names that have unsubscribed from an email, but

I am working on **a** simple spreadsheet of US time zones.
I have **a** list of numbers that I am working with and **a** list of area codes that fall into each time zones.
I need **a** quick **formula** **to** look at each number, reference the list of area codes (sheet 2) and identify which time zone each number belongs **in**.

Rectify the error **in** series **excel** **formula**, prompt action is required

i have an (embedded/nested?) if/then statement for **a** worksheet that i can not get **to** work.
it has lots of variables that i want **to** include **in** one long statement / cell instead of multiple ones (the only way I know **how** **to** do it).
I need **a** quick turnaround, if possible.

Hi,
I need you **to** proof Gauss's backward interpolation **formula** which mean **how** the **formula** became like this from the beginning.
I will give you the proof of Gauss's forward interpolation **formula** **to** help you understanding what I want.
please ONLY bid if you are **a** mathematician, understanding Methods of Numerical Analysis and understanding...

There's not much more than the title. I have **a** set of physics math that has been converted **to** **excel**. I have **a** couple more left and need someone with **a** physics background **to** help me convert them **to** **excel**.

We are measuring **a** sugar value with **a** refractometer during fermentation.
Due **to** the fact that alcohol is decreasing it influence the refractometer value and we do not get the right sugar content.
**To** compensate that we made measurements with other instruments **to** find **a** correction factor.
Of course depending on the start sugar value, the correction

See attached description.
- There rotating vector of fixed lenght L. Use L=1
- the vector projects onto ...and Y axis. These 2 axis are at 120 degreed (They are not 90o orhtogonal)
- knowing the projection Lx and Ly find the **formula** that gives the angle **a**
- provide **a** verification table showing that your **formula** always works with **a** from 0 **to** 360degrees

I have **a** very small and probably easy job that an **excel** expert can help me with. The **formula** is 2 calculations that depend on fixed data which can vary. Not sure if that makes sense but talk through briefly or email more detail.

...need someone **to** help me repair this COUNTIF **formula**
=IF(COUNTIF($E$1:$E$13300,E1)=1,"Unique",COUNTIF($E$1:$E$13300,E1))
Here also is **a** video which shows the difficulty that I am experiencing.
[login to view URL]
Assistance is greatly appreciated.
I will pay $4 for full completion of this task.
The solution must work **in** my existing

ONLINE FULL **EXCEL** TRAINING WITH ALL **Formula**

We are **a** leading organic baby food company. And we would like **to** invite you **to** help us broadcast our organic baby **formula** product throughout social media. **A** perfect candidate should:
1. Have connections or could help find 60+ Facebook and Instagram accounts **in** mom&baby, shopping, lifestyle, or other baby-related categories.
2. Reach out the accounts

I need someone who can decrypt an android apk and provide me the **formula** used for generating 2 header fields sent as http request.
It should be **a** 10 - 15 minute job for someone who knows **how** **to** do it. I am not looking for someone willing **to** learn and I will ignore bot bids.
Thanks.

Need help **to** automate my shipping website **to** allow it **to** give it instant quotes, I need the services of someone who is good **in** mathematics and can also help **to** design **how** we will produce our quotes

Hi I need someone **to** teach me salesforce development
the area i am intrested are:
Formulas
Apex
Trigger
I want someone **to** teach me until i get expert on these.
Thank you

We need **to** implement certain trading strategies for our portfolio management and automate it using Amibroker **Formula** Language(AFL)

Hi,
Please take **a** look at the attached document.
This shows an example of my 'dataset', and the layout of **how** I would like it **to** be transformed...
I would like **to** accomplish the "End Result" with the use of **a** **formula** only - and NO helper columns. - Array formulas are also fine.
** I don't want **to** use macros **
** I don...

Need **to** convert this **excel** **formula**: =-((G2+(G2*F2))*(((1+F2)^(C2))-1)/F2)
**to** **a** javascript, according **to** this:
[login to view URL]

I have an **excel** doccument, which I need **to** **create** **a** **formula** **to** search information by inserting the name of **a** student.

Hi,
Please take **a** look at the attached document.
This shows an example of my 'dataset', and the layout of **how** I would like it **to** be transformed...
Ideally, I would like **to** accomplish the End Result with the use of **a** **formula** only - and NO helper columns.
I have colour coded the data **to** make it easier **to** read.
Please take **a...
**

**
$24
(Avg Bid)
**

**
Excel Need a formula
Ended
$20
(Avg Bid)
$19 / hr
(Avg Bid)
**

I have **a** row of cells. each cell has an index match **formula**. I need **a** **formula** that will return the first value **in** the cell that is not ""
Attached is the sheet.
I want cell F11 **to** display the result from range G11:Z11

1. **Formula** for Markup
2. **Formula** for Volume Pricing
**A**. I have 3 files, same format on each file. Each file has Inventory Sheet & Markup sheet.
I (amatear) have used (If) **formula**, I know you can do better.
B. I have try **to** have volume discount **formula** and failed.
I use hidden columns.
I use Teamviewer.

...I have written **a** complicated pricing program **in** **Excel** and need assistance finishing it.
For this moment you are bidding on debugging the macro "Building 1" Located on the "Quote" Worksheet.
The winning person will:
*Have advanced knowledge of **Excel**.
*Be able **to** start immediately
*Be available for hourly work over the next 10 days **to...
**

**
$114
(Avg Bid)
**

**
$18
(Avg Bid)
Excel match formula
Ended
$21
(Avg Bid)
$25
(Avg Bid)
$26
(Avg Bid)
$103
(Avg Bid)
$89
(Avg Bid)
**
Need **formula** **to** calculate day and time for my **excel** sheet

I have some work, **in** an **Excel** spreadsheet.
It’s very simple.... basically just want **a** match **formula**

I have **a** signage Company and sell different signs. Some are standard and others custom made. **In** general we work on **a** per square meter (m2) price. I need **a** **formula** for pricing. Example: **A** sign is **A**:190mm x 190mm for $30 (works out **to** $831/m2). **A** sign B:290mm x 290mm sells for $58 (works out **to** $689/m2). If I only work on the Squa...

I need **a** **formula** or macro **to** extract URL’s and text between <**a** href> and </**a**> tags.
There could be up **to** 20 occurrences per cell.
All links merged into one column, and all the text between the anchor text **in** 1 column.
I do have **a** **formula** **in** sheet 1, cell D, but its not correct. I need it **to** be extende...

...three Formulas **A**, B, C, that need **to** be written mathematically, and possibly write an algorithm **to** go with it.
% PREPOSITIONS
% COMMON NOUNS
% PLURAL NOUNS
% BASE VERBS
% DETERMINERS
% ADVERBS
% PRONOUNS
% ADJECTIVES
The % is defined, but not **in** above example, since this post is public **to** freelancer.com.
What I Need is mathematical **formula** or algorit...

Need someone who can help with matching two different sheets **in** **excel** i.e. GDP growth rates for specific countries **in** specific years (**in** one sheet) and matching this with **a** new column ''GDP Growth'' **in** **a** sheet with premiums for M&**A**-transactions.