Question about Microsoft Excel for PC

1 Answer

What are the errors and formula

Errors and formula, at if and v look up

Posted by on

  • James Louie Puro
    James Louie Puro May 11, 2010

    please clarify your problems further. thanks.

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

Here are examples of the IF and VLOOKUP formulae and errors.

http://office.microsoft.com/en-us/excel/CH100645001033.aspx

Posted on May 22, 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

I need to write a formula in a cell but need the little green triangle in the left hand corner of the cell for it to except the formula


The Little Green Triangle (LGT) is an indicator to alert you to a potential error in your formula. The LGT doesn't stop you from entering a formula (with or without an error), it's just an alert to check that it's OK. If you're happy with the formula you've entered, then you can just ignore the LGT and carry on.
If it's bugging you, you can turn off background error checking.
Go Tools / Error Checking / Options / and uncheck "Enable background error checking". That will turn off the LGTs.

Sep 07, 2014 | Microsoft Excel for PC

1 Answer

Bad formula error


Bad formula error on what?

Feb 24, 2013 | Computers & Internet

1 Answer

Whenever I work in excel 2007 file.It show compatibility mode n top and any formula are not working properly in file.


When you open Office 2003 files with Office 2007, it works in compatibility mode, so that if you open the files in earlier version (i.e. Office 2003 etc) there would be no issues (reverse compatibility with earlier versions.
Regarding formulas, rest assure that compatibility mode does NOT affect the calculations at all. All formulas are reverse compatible.
So, it is recommended that you may save the file in Word/ Office2007 format. Do review your formulas for errors (if any).

CreativeTECH

May 16, 2011 | Computers & Internet

2 Answers

Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that when the formula works it will not calculate several columns if...


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

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

When I create a formula in a cell, hit enter, I get #VALUE. How do I get the actual result to appear, instead of #VALUE?


#VALUE? is an error indication meaning that Excel can't process the formula. It is most likely the result of a bad cell reference in your formula, for example, you may be trying to perform mathematical operations on a cell that contains non-numeric text data.

Jul 21, 2009 | Microsoft Office Excel 2007

1 Answer

I want verify the data drop town list and its formulas


Hi Manjee,

There is no formula used in data dropdown list, so it can not be verified as a formula using evaluate formula, trace errors, trace dependents, trace precedents etc.

If you want to create such lists simply:-
  • Select input range then goto
    data --> validation --> allow, list --> select the list range
  • To veryfy you can follow the same process
    data --> validation --> allow, list ,
    now you can see the exact range from where the data is picked.
Thanks

Zulfikar Ali
ali_zulfikar@yahoo.com
09899780221

Jan 19, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Daily Payroll Time Sheet Calculation


=IF(C3-B3>6,(C3-B3-1)*24,(C3-B3)*24)

Is this what you want ???

B3 has start, C3 has end, formula is in D3

Aug 12, 2008 | Toshiba Satellite A100-S8111TD Notebook

1 Answer

Works suite 2006 spreadsheet


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

Mar 02, 2008 | Microsoft Windows XP Home Edition

Not finding what you are looking for?
Microsoft Excel for PC Logo

71 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...