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

Ad

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

Ad

Try this: =IF(B13+(B13*B$7/12-B$10)<0,0,B13+(B13*B$7/12-B$10))

Jul 07, 2015 | Microsoft Excel for PC

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...

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...

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:

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 FIXYAPlease rate us if you are happy :) **

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

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.

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

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)

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

Jun 03, 2009 | Haier Chest Freezer HNCM070E

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)))

Need more information on what the numbers are to help further

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)))

Need more information on what the numbers are to help further

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

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.

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

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

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

121 people viewed this question

Usually answered in minutes!

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.

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

×