Question about Microsoft Excel for PC

1 Answer

My Problem with IF Function ,Can u help Me PLZ :(

When I use :

IF(AND(C3>=95),"5.0",IF(AND(C3>=90),"4.75",IF(AND(C3>=85),"4.5",IF(AND(C3>=80),"4.0",IF(AND(C3>=75),"3.5",IF(AND(C3>=70),"3.0",IF(AND(C3>=65),"2.5")))))))

and I wana add (C3>=60),2.0
(C3<60).1.0


the formula I type containe an error...
how Can I solve it !


Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 36 Answers

You don't need the AND statements, just the IF:

=IF(C3>95,"5.0",IF(C3>90,"4.75",IF(C3>85,"4.5",IF(C3>80,"4.0",IF(C3>75,"3.5",IF(C3>70,"3.0",IF(C3>65,"2.5",IF(C3>60,"2.0","1.0"))))))))

I tried it several times and it works like a charm!

Posted on Jan 04, 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:

8 Answers

Serial activation code for city car driving v 1.3


Product Code: 654812-0FB6-C466

I am waiting plz :(

Mar 25, 2014 | Computers & Internet

1 Answer

I can't get the product key from anywhere !!! plz plz if you have the answer plz help me because it is soooo argent !!


Yes you can get a product key if you buy it.
MS product keys are part of a retail or OEM package you can't just load up Offie for free and then use a rip off key - this is illegal.

Feb 25, 2011 | Microsoft Office Standard for PC

1 Answer

How i get data from html form to ms access or excel file...????


this needs to be programmed - i.e. when you submit the form it needs to be submitted to something (e.g. java servlet, php script, etc.) that will take the data and insert it into a data store (access, excel, mysql, oracle, etc.)

Apr 09, 2009 | Microsoft Office Standard for PC

2 Answers

Sigmatel s22 :- I tried china pc suite,but unable to install java


Sigmatel S22 will not support java or any other OS. Chinese phone have their own operating system. With a chinese phone you will not be able to install any new software. S22 also does not supports installtion of NES games.

Its only good for Music, TV and phone function.

Jan 11, 2009 | Handmark Software MobileLists (950142) for...

1 Answer

What is vlookup & hlookup?


1024x768 Normal 0 false false false /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} These are Excel functions for Lookup tables. The purpose of Lookup tables is to bring a value to the table, find the closest (or exact) match, and then return another value.

An example is the federal income tax table. On your tax return you get your gross income and number of dependents, go to the Lookup table, and find your taxable income.

The V in VLOOKUP means that the table is vertical; HLOOKUP has a horizontal orientation.

If you use the Insert Function button in Excel and paste either function, the dialog box will explain each required field separately with examples.

Dec 02, 2008 | Microsoft Excel for PC

3 Answers

Sigmatel


i have a sigmatel s4 mobile my phone was reaching in flight mode. Not working Mobile. Plz help me

Nov 05, 2008 | Handmark Software MobileLists (950142) for...

1 Answer

Plz answer, thanks!!


Click the Office Button in the upper left corner. Click "Save As"
Click "Tools" and select "General Options"
function go(url) { window.open(url, "_self"); } function OpenInNewWindow(url) { go(url); } function go(url) { window.open(url, "_self"); } function OpenInNewWindow(url) { go(url); }
There you can set a password to open the file or a password to modify the file.


function go(url) { window.open(url, "_self"); } function OpenInNewWindow(url) { go(url); } function go(url) { window.open(url, "_self"); } function OpenInNewWindow(url) { go(url); } function go(url) { window.open(url, "_self"); } function OpenInNewWindow(url) { go(url); }

Jun 25, 2008 | Microsoft Office Professional 2007 Full...

3 Answers

Product key


Ms Office 2007 Enterprise Edition

Serial #: DTWPQ-BJ4FY-R84YP-H36M2-FMVD8

from garin07@yahoo.com

Feb 10, 2008 | Microsoft Office Professional 2007 Full...

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

158 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

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