Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC

# I need help with the "if/then" formula on microsoft words spreadsheet

Posted by on

×

• Level 1:

An expert who has achieved level 1.

• Contributor

A B C D E F 5 TRUE 5 TRUE 5 TRUE 6 3 6 3 6 3 red blue red blue 27 blue

If :-

=if(A3<=7;A3*5;0)
It will show the resuls 30.

Above table shows if A3 is less than or equal to 7 then A3 should multiply by 5 otherwise result zero. Therefore A3 in this table is less 7 then hence it has multiplied by 5 so result would be 30.

Posted on Jan 21, 2009

Hi,
A 6ya expert 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 repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### I have a spreadsheet set up with columns which have dollar amounts which need to be added or subtracted. How can I set up a formula to do this automatically without me manually doing it on each line.

Best bet would be to utilize the "Help" function for formulas. You will need to set up a formula for each column you would like to format. Or simply add a Function (123-456) or (123+123) That way the cell will know the math. Good Luck

Feb 10, 2015 | Microsoft Office 2010 Home And Student...

Made by Microsoft, used for creating, opening and managing spreadsheet data files created with the application. Spreadsheets allow you to manipulate numbers, formulas, information and extrapolate resulting information, graphs, charts, organized lists, export data to create all sorts of useful results.
Not sure what else you want to know...

Aug 22, 2012 | Facebook Computers & Internet

### What is the function of Microsoft excel?

Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

### I need a running balance in a column for a petty cash spreadsheet

In the first row of numbers, assume row 3 for example (leaving 2 rows for titles, put in cell E3: =C3+D3. In the next row (assuming row 4, put in cell E4: =C4+D4+E3. Use fill down to populate this formula all the way down.

Jun 18, 2009 | Microsoft Excel for PC

### If/Then Formula

not really
Just create the
formula =if(e1=1,"X",if(e1=2,"Z","")) in cell K1 then
formula =if(f1=1,"X",if(f1=2,"Z"),"") in cell L1 then
formula =if(g1=1,"X",if(g1=2,"Z","")) in cell m1 then
formula =if(H1=1,"X",if(h1=2,"Z","")) in cell N1 then
if you wanted another statement
formula =if(H1=1,"X",if(h1=2,"Z",if(h1=3,"Y,""))) in cell N1
this is nesting the if statement you just keep adding conditions.
What you are asking I have to type this in 600 times
No just do one line and then highlight the cells with the if in it and then select copy from edit menu or right click and select copy
Then click on next 599 cells by clicking on first cell and hold mouse button down and drag down mouse to last 1000 row of cell and right click mouse and select paste. The formulas will alter accordingly as pasted to each cell

You could also use a vlookup statement
you open another workbook look at bottom of worksheet for tabs to add a workbook.
Then you create a table in other workbook
1 cell A1 H in B1
2 cell A2 Z in B2
https://www.timeatlas.com/vlookup-tutorial/
you would still need to copy the cells down

Mar 30, 2017 | Microsoft Office 2003 Basic Edition...

### Percentage formula

=(Click cell that you want to work out 30% of)*30/100

Nov 30, 2008 | Microsoft Excel for PC

THERE MAY BE ERROR IN OFFICE INSTALLATION SO PLZ UNINSTALL YOUR OFFICE AND REINSTALL THE OFFICE

Mar 02, 2008 | Microsoft Windows XP Home Edition

### Excel Formulas

Get on Excel web sight and look at Excel Tutorial close to bottom of page. Follow the instructions.

Sep 17, 2007 | Microsoft Office Standard for PC

### Creating a holiday accrual spreadsheet.

Hi, I guess you mean vacation accrual. It's hard to help you here, without knowing the exact accrual formula. However here are some tips: Set up a column with the start date for each employee and use the today() function to get today's date. You can use the days360() funtion to calculate the number of days between two dates, assuming regular 30 days/month. For more date related functions, click on the Fx (letter f with an subscript x) to the left of the value/formula entry field at the top of the spreadsheet. Thsi gives you a wizard with a list of functions. Select the Data/Time group and you see all available functions and can interactively pull them together. Good luck K

Sep 05, 2007 | Microsoft Office Standard for PC

### Excel

The Data Analysis Add-in has a Moving Average fuction and wizard. Moving Average

Aug 30, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

84 people viewed this question

Level 3 Expert

Level 3 Expert