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

Ad

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

Ad

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.

Good luck!

Posted on Jan 02, 2017

Ad

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

Not sure what else you want to know...

Aug 22, 2012 | Facebook Computers & Internet

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

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

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

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

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

=(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

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

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

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

Aug 30, 2007 | Microsoft Office Standard for PC

84 people viewed this question

Usually answered in minutes!

i need product key for microsoft office standard edition 2003 please help

My E mail ID shah_ujwal@yahoo.com

×