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.

×

Ad

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

Ad

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.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Please help me to solve the circular reference in 2013 excel file which stop opening the file. Thank you


first start excel and click on formula tab -->Calculation options -->Manual
excel1-yi4l5i2224qkwob0czw2k0fe-5-0.pngNow open file, if asks for update formulae, say no.
Now select entire sheet, select formulas tab--> Error Checking -->Trace Error.
excel2-yi4l5i2224qkwob0czw2k0fe-5-2.png It will locate all error containing cells, now rectify the error save it reopen in excel to see if problem is solved.

Apr 12, 2017 | Microsoft Excel for PC

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

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?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

73 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2993 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

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

Answer questions

Manuals & User Guides

Loading...