Amending an if statement

**isolation123** · 03-04-2008, 08:39 AM

hi guys does anyone out there know why this formula does not work:

=IF(H29=>70,"1st",IF(H29>=60AND>=69,"2:1",IF(H29>=50AND>=59,"2:2",IF(H29>=40AND<=49,"3rd"))))

The formula is to work out the class of an honours degree for a certain student.

thanks guys.

**NBVC** · 03-04-2008, 08:45 AM

Should probably be:

=IF(H29>=70,"1st",IF(AND(H29>=60,H29<=69),"2:1",IF(AND(H29>=50,H29<=59),"2:2",IF(AND(H29>=40,H29<=49),"3rd",""))))

or more simply:

=LOOKUP(H29,{0,40,50,60,70},{"","3rd","2:2","2:1","1st"})

**EdMac** · 03-04-2008, 08:46 AM

Hi,

=IF(H29=>70,"1st",IF(H29>=60AND>=69,"2:1",IF(H29>= 50AND>=59,"2:2",IF(H29>=40AND<=49,"3rd"))))

You don't need AND. The logic is: if more than 70 1st, else if more than 60, 2nd etc

change to

=IF(H29=>70,"1st",IF(H29>=60,"2:1",IF(H29>= 50,"2:2",IF(H29>=40,"3rd"))))

Ed

**isolation123** · 03-04-2008, 08:55 AM

thanks guys it works now!!!

**isolation123** · 03-05-2008, 09:41 AM

hi guys i have an if statement that does not work here it is:

=IF(360>J10>300,"pass","Fail")

the if statement is to work out if a student has got a degree or not they have to have between 300 and 360 to be awarded a degree otherwise they fail.

thanks guys!

**arthurbr** · 03-05-2008, 09:47 AM

=IF(and(j10<360,j10>300),"pass","Fail")

**isolation123** · 03-11-2008, 11:49 AM

hi guys i am creating a system for offering degree's and honours degree's. i need it so when the subject dissertation is taken they can be awarded an honours but when it is not taken they cannot i am using this formula which works to work out the honours at the moment =IF(H5="Fail","",IF(G29>=70,"1st",IF(G29>=60,"2:1",IF(G29>=50,"2:2",IF(G29>=40,"3rd",)))))

is there anyway i can do this by adding anything to the formula i have already got?

thanks guys i appreciate it alot!

**Mark@Work** · 03-11-2008, 02:18 PM

Is this the sort of thing you are thinking of?

=IF(OR(H5="Fail",D5="no dissertation"),"",IF(G29>=70,"1st",IF(G29>=60,"2:1",IF(G29>=50,"2:2",IF(G29>=40,"3rd",)))))

**isolation123** · 03-12-2008, 09:38 AM

thanks very much for your reply but please could you explain the D5 bit??

**Mark@Work** · 03-12-2008, 12:35 PM

D5 is just a cell I chose at random to hold the information of if the dissertaion was handed in or not.
Where this iformation is actually held (and what format it is held in) is entirly up to you.

Mark.

**isolation123** · 03-12-2008, 02:30 PM

would it be possible to do the same formula but have a range of cells where the dissertation could be??

**isolation123** · 03-12-2008, 03:06 PM

Hi guys

i have this formula below which works but where it says IF(B45="Dissertation" instead of b45 i need a range of cells where the dissertation could be.

=IF(H5="Fail","",IF(B45="Dissertation",IF(C45>39,IF(F37>=70,"1st",IF(F37>=60,"2:1 ",IF(F37>=50,"2:2",IF(F37>=40,"3rd",)))))))

thanks very much for your help!