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

1 Answer

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

Posted by on

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Computer question. looking for formula that will allow me to enter info into one spreadsheet on Microsoft Works and it will automatically enter it to another spreadsheet.


The operation is called Select-Copy-Paste.
If you want to copy a full page, select all (CTRL A) on the original page, copy it (CTRL C) then paste selection (CTRL V) on the other page.

Feb 27, 2011 | Microsoft Works 8.0 for PC

2 Answers

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

3 Answers

NEED TO AVERAGE CELLS, WHERE ONE OR MORE CELLS CONTAIN ''0'' OR ''#D


Try this. If any of the cells are zero (or blank), the word 'zero' will be displayed. Substitute anything you want for the text including blank ""

=IF(OR(F61=0,J61=0,N61=0),"zero",AVERAGE(F61,J61,N61))

Aug 26, 2009 | Microsoft Office Excel 2007

1 Answer

What is formula new excell


I certainly can't take the time to explain v lookup to you in this forum, but I can direct you to several sites that you can familiarize yourself with it. It's going to take you time to to understand it.

http://spreadsheets.about.com/b/2008/03/17/excel-vlookup-3.htm

http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm

http://www.techonthenet.com/excel/formulas/vlookup.php

Jun 21, 2009 | Microsoft Business & Productivity Software

2 Answers

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

1 Answer

Percentage formula


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

Nov 30, 2008 | Microsoft Excel for PC

1 Answer

Excel Spreadsheet


It could have a virus or simply too much data in it or too much data linked to it. Try doing a copy of the whole spreadsheet, and then paste the data into a new spreadsheet. If it doesn't contain too many different formulas, try pasting only the values, and then replace the formulas manually. You might also try just deleting the links, if there are any. If this doesn't solve it, reply to this thread and let us know.

Hope this will FixYa!!!

Sep 30, 2008 | Microsoft Excel for PC

1 Answer

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

1 Answer

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

1 Answer

Excel


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

Aug 30, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office 2003 Basic Edition English (s55-00066) for PC Logo

82 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18330 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...