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

Hi,

a 6ya Technician can help you resolve that issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.

click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

Ad

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

How many watts you
need depends on the type of plants and the volume of the tank. Here is an excerpt from an article that will
help you determine proper wattage.

Instructions

Identify
the species of plants you have in your tank or that you plan to put in your
tank and how much light that species needs. Each species of plant will have an
optimal lighting requirements, from low light to bright light. To determine the
plant species, compare photos on the Aquarium Plants Photos and Profiles page
of the Aqua Hobby website, or take samples of the aquatic plants to your local
aquarium store for identification.

Write
down how much lighting each of the plant species in your tank needs. Give each
plant a rating of low, medium or bright. The books "The Complete
Fishkeeper" and "Freshwater Aquariums for Dummies," as well as
your local fish store, are good sources of information for this.

Review your
list and determine what type of plant dominates your tank. For example, if you
have mostly plants that need bright light, then use a bright-light formula. If
you have an equal mix of plant lighting needs, then use a medium-light formula.

Calculate
a range of watts of lighting you need for your tank with one of the following
formulas, depending on the amount of light you determined you needed for your
plants. For low light, multiply one and two by the number of gallons. For
medium light, multiply two and three by the number of gallons. For bright
light, calculate three and five by the number of gallons. For example, for a
20-gallon tank with plants that need medium light, you would get a range of 40
to 60 watts (2 x 20 = 40 and 3 x 20 = 60).

Read more: How to Determine Watts Per
Gallon for Aquarium Lighting ' eHow.com http://www.ehow.com/how_8014286_determine-per-gallon-aquarium-lighting.html#ixzz23KB8HErA

Aug 14, 2012 | Fish

I am pretty sure I got this as a homework assignment in programming class. If I had someone give it to me then I wouldn't be even the limited programmer I am now. That said, I will help, but I will not give you the full out answer.

dia star = number of lines before star and "*"

print dia star

NOLA Tech

- The number of stars and characters per line are an odd number to make the ASCii look like a diamond. For my example, the maximum number of characters per line is five.
- Create a variable called dia_star that will hold the spaces and stars. To figure out the number of spaces that should be put into each star line, use this formula:

dia star = number of lines before star and "*"

print dia star

- --*--
- -***-
- *****

NOLA Tech

Jan 30, 2010 | Microsoft Visual Basic Enterprise Edition...

Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

the basic idea of an if statement is just that if this then that. Thus a formula could look as simple as =IF(A2=1,25,IF(A2=2,10))

Jan 10, 2009 | Computers & Internet

this is done through formulas. You write them in relationship to one another. Say you put a value into B1 then you write a formula for c2 like =SUM(A1/2)which means the sum of A1 divided by 2. or you can say make a formula that is like this =SUM(A1/C1) which means the value of A1 divided by the value of C1.

Jan 10, 2009 | Computers & Internet

Hello cbw@netzero.com,

The source code request would be for a program code, appropriate if you actually wrote the code for the Excel program, but if you are copywriting a set of formulas or an excel execution sequence, then you want to print your formula view for copywriting.Excel has a Formula View that shows the formulas on your worksheet rather than the results of those formulas. You toggle between Formula View and Normal View by pressing CTRL ~ on your keyboard. Just toggle to formula view and print your worksheet to see all of your formulas.

Good luck with your copywrite!

The source code request would be for a program code, appropriate if you actually wrote the code for the Excel program, but if you are copywriting a set of formulas or an excel execution sequence, then you want to print your formula view for copywriting.Excel has a Formula View that shows the formulas on your worksheet rather than the results of those formulas. You toggle between Formula View and Normal View by pressing CTRL ~ on your keyboard. Just toggle to formula view and print your worksheet to see all of your formulas.

Good luck with your copywrite!

Oct 06, 2008 | Microsoft Office Professional 2007 Full...

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

Suppose your Basic Amount is in cell A5 then write a formula in B5 - If(A5*0.3>5000,5000,A5*.03) and copy this formula to all cells in coloumn B .

Oct 12, 2007 | Microsoft Office Standard for PC

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

115 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

×