Question about Microsoft Excel for PC

# WRITING A LONG IF AND THEN FORMULA

I have several if and thens that i need to put into a formula per line. Can not get it to take it. I have wrote these formulas for years but got vista and now having problems

Posted by on

• sulney Oct 06, 2008

i have columns of data where i wish to take information from one then the next and so on but that which relates to the person in column 1 who may appear there on numerous occasions.

• shujat_hussa Nov 08, 2012

please visit to learn all excel functions and formulas All-in-One Excel Functions and Excel Formulashttp://atips4pc.blogspot.com

×

### Anonymous

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotĀ 5 achievements.

Governor:

An expert whose answer gotĀ voted for 20 times.

Scholar:

An expert who has written 20 answers of more than 400 characters.

• Expert

The OS should not impact on the performance of Excel..
Have you upgraded excel from 2000 to 2007 ??

Power formulas are tricky to manage at the best of times.
The formulas that you have wrote for years may have been on the knife edge ... i.e. just less than 256 characters.
Have you exceeded this limit ??

Posted on Aug 17, 2008

×

my-video-file.mp4

×

## Related Questions:

### I have a vehicle which have moved for 2383 kilo meters and used 320 liters of diesel what should be the consumption rate

school work you should solve by yourself... not by fixya...

you have following data:
v = volume = 320liters
d = distance = 2383km (kilometers is a single word...)

there is several formula to solve this mathematical problem, if you want how many liters per 100km formula is as follows:
(v/d) x 100 = 100km/ltr just substitute your data

if you hear then that vehicle is using 7.5ltr/100km that was the formula. unfortunately - you need to calculate your own data, this was just an example...

another variation is distance per liter, there is formula:
d/v = distance (kilometers) per liter

if you hear that car is driving 11km/ltr - that is again, and example, you need to calculate your own data...

enjoy! and vote...

Feb 10, 2015 | Haier DWL3525DDBB 24 inch Built-in Tall...

### How do you put the soultion in and how do you use it

Here is link to the users manual:

http://www.bissell.com/assets/0/132/134/228/14489708-7c37-4678-a90a-79e6825ef104.pdf

but real quick, heres the essentials:

Fill the SmartMix/formula tank

Lift the formula tank up and out of the machine base.

Fill the formula tank

by first unscrewing the cap

and insert. Always use genuine BISSELL formulas

to maximize cleaning and for the safety of your

machine. Fill formula up to the line and replace the

cap and insert. Place formula tank into the slot in the

back of the machine for a snug fit.

2b.

If using the BISSELL 3X Concentrated Fiber Cleansing

Formula: Add 3 capfuls of 3X Concentrated Fiber

Cleansing formula to the formula tank, and then fill

with warm water to the line.

Note: If bottle leaks, check for proper positioning

of red gromment and straw insert.

Good luck and thanks for using FIXYA

Please rate us if you are happy :)

Apr 06, 2011 | Bissell 1697-7 Powersteamer Pro Deluxe...

### Create a program that will the salary, no of hours work, the deduction, total deduction and net pay.

The easiest way to do this is to use Excel spreadsheet.
This is what you need to do.
Create a label at the top of each column as detailed.
Add a employee to each row under Name of employee
Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee
2nd column - salary rate per hour
3rd column - hours worked
4th column - gross pay (formula = salary rate X hours worked)
5th column - tax deduction
6th column - other deductions
7th column - total deductions (formula = tax deduction + other deduction)
8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.
You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

Mar 24, 2011 | Computers & Internet

### Formula for excel to calculate years of giving.

In AJ3 thru BT3 put a number. Doesn't matter what number. Then type the following formula into a cell and instead of pressing enter press and hold control, then press and hold shift, and then press enter, and then release all the keys.

=COUNT(IF(NOT(ISBLANK(AJ2:BT2)),AJ3:BT3)

Jun 03, 2009 | Haier Chest Freezer HNCM070E

### If formula

What are the "cases"? Your example "more then 8 or less then 9 use 400" implies that there is a decimal part e.g. 8.5 . Is that right?

You dont need to test in both directions
e.g. assuming you name the cell with your number in it "cases"
=if(cases<9,400,if(cases<10,410,if(cases<11,420,430)))

Aug 07, 2008 | Microsoft Excel 2000 Step by Step...

### Excel formula.....

Let's start with the 1st equation. I assume you want to be able to recalculate by changing the number of pages.

Put 65 in cell a1.
360 in b1
In C1, put the formula =a1/b1 that's your book thickness
In D1, put .02 for the cover
In E1, put the formula =C1+D1

Now you can change A1, B1,or D1 and the Total thickness gets recalculated automatically. Be careful not to type numbers into C1 or E1, or you lose the formula.

The same for the other equations - a cell for each number ("variable") and another cell for calculations.

Once you've verified the results, then you can get fancy and add titles above each field to make it easy to remember what goes where.

You may need to change the cell format to control the number of decimal places, or thousands commas. Right click on a cell and select format to see the choices you have.

Keep a backup copy of the spreadsheet in case someone (not you, of course) makes a mistake and overwrites the formula cells. You can also look into "protecting" cells to keep them from being changed.

Hope that helps.

Jul 14, 2008 | Computers & Internet

### Excel formula

Relative cell reference is address of cell , when copied from one cell to another gets changed automatically.

e.g. Put formula in cell c5 as A5+1 when you copy this from c5 to c6 the address of A5 will automatically changed to A6.

Absolute Cell Reference

As above now put formula in cell C5 as \$A\$5+1 ,now copy this formula from C5 to C6 if you this formula youwill find cell Address of A5 does not changed.

Mixed Cell Reference:

If we put Dollar (\$) sign before Alphabetic cell address i.e.\$c5 then even if you copy this formula in any cell , coloumn (c)  will remains constant.

Similarly if we put Dollar (\$) sign before Numeric cell address i.e.c\$5  then you copy this formula in any cell row address of the cell remains same.(5).

Pl elobarate on remaining two points 'Specific order of formulas ' and 'advance formulas,

Sep 15, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

121 people viewed this question

Level 3 Expert

Level 3 Expert