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:

2 Answers

How to 3G Function in Nokia 5230? plz rpy.


check whether the phone has 3g functionality.if yes then for functionality of 3g you must use sim of correct service provider enabled with 3g.

Aug 11, 2010 | Nokia 5230 Cell Phone

1 Answer

Plz plz help me im a complete pc novice and i need help gettin my ps3 online threw a laptop and ethertnet cable keep gettin dns error this seems a common problem i have an o2 usb modem any help would be...


You need to have a wireless connection. Anotherwards you will need to buy a wireless router and connect it to your Modem and configure it properly if you want it to function normally. If you need a walkthrough for setting up your router i can post a link.

Jul 31, 2009 | Sony Video Game Consoles & Games

1 Answer

Malfunctioning of switch on function


hi thanks for using fixya!

What is the model of your phone?

Let me know.

Apr 04, 2009 | Computers & Internet

1 Answer

Display driver


  1. Right click 'my computer'
  2. select 'manage'
  3. select 'device manager' 
  4. locate your monitor 
  5. right click your monitor
  6. select 'update driver'
Same goes for you keyboard.

Jan 05, 2009 | Toshiba Satellite A60-S166 Notebook

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

26 Answers

Request for Base Transceiver Station (BTS) Installation, Commissioning, Integration, Reengineering, Rdio add introductary data


It differs from product to product

I would sujjest first  you choose a product for a base station installation and commisioning and then read their manual

This way you can learn

Feb 23, 2008 | Computers & Internet

1 Answer

Defective mode function switch


possibly the contact points are damaged. plz check with the help of a electronics repairman.

Feb 17, 2008 | Cameras

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

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