Question about Microsoft Excel for PC

1 Answer

Ms excel function

I need to know a function that i can for excel.

i will use it for scoring.

say for example:

a = 3

b = 2

c = 1

d = 0

is there a function that I can use to do this? I will be using at least 5 categories. please help me.

Posted by on

  • Tonette21 Feb 26, 2008

    please help me create the function

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 155 Answers

I'm not entirely sure how you want to use this, but it is fairly easy to automatically assign a value to a cell based on the value in another.

Let's assume that you enter your score (A, B, C or D) in cell A1. If you put the following equation in cell A2 it will then display the corresponding score:

=IF(A1="A",3,IF(A1="B",2,IF(A1="C",1,IF(A1="D",0))))

You can go on adding as many further 'IF' statements as you like.

You can elaborate on this a bit by changing it to the following:

=IF(A1="A",3,IF(A1="B",2,IF(A1="C",1,IF(A1="D",0,"Not Scored"))))

By adding the final 'Not Scored' entry it prevents cell A2 from displaying 'FALSE' as an output.

Matt

Posted on Feb 26, 2008

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

From Service Pack 3 with Microsoft office 2007, how do i change my operating system to MS office 2007?


Hi, there!
As I know, MS office is a software to use for office works such as typing document, calculate and basic office database. MS Office software is NOT an operating system. You can not change you operating system to MS Office 2007. I think you meant is: Install Service Pack 3 of Microsoft Office 2007 on your computer. To do so, you first need the Microsoft Office 2007 software on your computer or you need MS Office 2007 disk. The Service Pack 3 of MS Office 2007 is the update only not the actual software to use.

Hope this will help. Thanks for reading.

Jul 20, 2011 | Computers & Internet

4 Answers

How to convert 2007 excel sheet into 2003 excel sheet


if you have excel 2007 you can save the file into excel 2003 compatibility

if you have excel 2003 need download compatibility pack from this page
http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
install it and success!

Feb 22, 2011 | Computers & Internet

1 Answer

Need Help Solving Exponential Functions ASAP!!!!


You can calculate =4^1.2 in Excel and get 5.278031643
And also in Excel you can determine what the square root of 2 is (2.506628274631) and then in Excel = 5 ^ 2.506628274631 = 56.5012395907155.

I know this is late but maybe it will help later. Assuming I am doing it right. Thanks!

Mar 29, 2009 | Texas Instruments TI-30XA Calculator

2 Answers

Wanted to learn "ALL" formulas of MS Office Excel - please guide


Ist I want to know what type of formulas u use in works

Jan 13, 2009 | Computers & Internet

2 Answers

Formula for calculating the days beween months


for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

1 Answer

=if


=IF(C5>B5,0,B5*2)
this means if it is true that C5>B5 then the cell = 0,
but if it is not true, means C5< or = B5, the cell will be B5*2
You can change the numbers as you need.
To use function easily, you can click "Insert" --> function --> then choose in the "select a function" -> OK.
Then follow the instructions. Very clear to follow

Feb 29, 2008 | Microsoft Excel for PC

1 Answer

Hello this is ibbu


Their is not enough room to post all the functions of excel. Is their something specific you need to accomplish?

Oct 10, 2007 | Microsoft Office Standard for PC

2 Answers

Ms excel


Try clicking the down arrow beside the autosum button in your Excel Standard toolbar. Then click More FUNCTIONS. An Insert Function dialog box appears. There use can explore all MS Excel functions.

Oct 10, 2007 | Microsoft Office Standard for PC

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

Related Topics:

94 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18385 Answers

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

Answer questions

Manuals & User Guides

Loading...