IF and OR - adding additional criteria

[ynottony]

Hi, I'm stumped with my formula, I'm trying to add another criteria to the below, so basically if the value added together is less than 5 but NOT 0, then show as 'L/N', any help will be greatly appreciated.
the text in red is OK, it's just the text in black, currently it shows 'L/N', if the value added together is 0.

=IF(IFERROR(GETPIVOTDATA("Student Id",'Other Criteria'!$A$7,"Campus Name",C30,"Course Code",A30),0)+IFERROR(GETPIVOTDATA("Student Id",'Other Criteria 2'!$A$7,"Campus Name",C30,"Course Code",A30),0)<5,"L/N",IFERROR(GETPIVOTDATA("Student Id",'Other Criteria'!$A$7,"Campus Name",C30,"Course Code",A30),0)+IFERROR(GETPIVOTDATA("Student Id",'Other Criteria 2'!$A$7,"Campus Name",C30,"Course Code",A30),0))

[BoredWorker]

Did you mind to reset the formula from GETPIVOTDATA to the location of the cell? (ie A1,B1....) it let the formula look shorter.

PS: if it is different sheet, put the sheet name in front (a), if the sheet name got space look for (b).
(a) Sheet1 = Sheet1!A1
(b) Sheet 1 = 'Sheet 1'!A1

Basically, it should be use AND function. but it too long for the formula, below just the logic, hope you understand.

your error is the bracket ,
=IF(A1+A2>5,"L/N",B1+C1) become =IF((A1+A2)>5,"L/N",B1+C1)


add in the AND function
=IF(AND(A1+A2>5,A1+A2<>0),"L/N",B1+C1)