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!
TELL US , if you have any answer
Sponsored ads
TAG cloud
different condition statements excel I 039 m currently revising worked subject Biology Chemistry Physics revise because it 039 s number higher statements actually between subjects inputting this
IF I4 I8 quot Biology quot quot Chemistry quot
but between Chemistry Biology Physics
All appreciated thanks
0