Question

EXCEL COMMANDS

Answer 1

i was making a database of My marks in an exam

Suppose i got 35 marks out of 40 ..

I want to set it as division what should i do ?

It is of logical formula

@ParthKohli

Answer 2

@rebeccaskell94 can u help me?

Answer 3

@lalaly

Answer 4

*sorry rebecca for tagging u .. but i needed help*

Answer 5

Like just do 35 divided by 40? I'm not quite sure I understand your question.

and no worries :)

Answer 6

=if(B2>=?) some what like this command

Answer 7

ohhh I don't know that :( Sorry D:

Answer 8

No problem @lalaly do u?

Answer 9

@shadowfiend or @farmdawgnation might know. They are like computer geniuses

Answer 10

what about cshalvey?

Answer 11

Ummm well we can tag him but I'm not sure that computer type work like that is is expertise. I could be wrong though. @cshalvey

Answer 12

@lgbasallote ?

Answer 13

I know this! Conditional Formatting!

Answer 14

You want to make different intervals, right?
0-10
11-20
and something like that?

Answer 15

Yes i want to mark division for example:

20-30 marks -> 1 division
30-40 marks --> 2nd division and soon

Answer 16

And what do you want to do with them? Write the division in a different cell?

Answer 17

Yea

Answer 18

That's where Conditional Formatting comes in, or you could also use the if command.

Answer 19

=if(A2>=20 .

then ?

Answer 20

If you have entered the marks in A1, then here's what you should do:
=IF(A1>=20,"20-50","1 - 19")

Answer 21

The normal format is:

=If(Make Excel test something, What it does if it's true, What it does if it's false).

Answer 22

Hmn thanks a lot
i got it

Answer 23

You're welcome! :)

Answer 24

If you want multiple intervals, then you must try conditional formatting.

Answer 25

Hmn i will do that tomorrow :
)

Answer 26

http://www.techonthenet.com/excel/formulas/ this would help