Question #6300213

How to have three different condition in If and Else statements in excel?

I'm currently revising for my exams and have worked out how many pages to do every day. I would like to have a cell where it says which subject out of Biology, Chemistry and Physics I need to revise most for because it's pages per day number is higher than the rest. I know about If and Else statements in Excel but have no idea how to actually apply them. I can make it tell me between two subjects by inputting this: =IF(I4 > I8,"Biology","Chemistry") but have no idea how to make it tell me between Chemistry, Biology and Physics. All help appreciated thanks!

0000-00-00 00:00:00

TELL US , if you have any answer

There is NEVER a problem, ONLY a challange!

The is a free-to-use knowledgebase.
  The was started on: 02.07.2010.
  It's free to register. Once you are a registered user, you can ask questions, or answer them.
  (Unless registration you can just answer the questions anonymously)
  Only english!!! Questions and answers in other languages will be deleted!!

Cheers: the PixelFighters


C'mon... follow us!

Made by, history, ect.