I WANNA AD AN IF CONDITION IN THE IF THE CONDITION IS TRUE PLACE LIKE : IF (G5> 0, IF(G5 > 6, "BIG", "SMALL"), "")
=IF(G5>0, IF(D6>0, IF(G5>D6, G5-D6, 0), G5 E6),IF(D6<0,IF(E6>F5, E6-F5, 0),0))
CodePudding user response：
In your case, G5 is 6000 and D6 is 7000.
So all conditions are FALSE in your IFS() formula and it returns #N/A.
To provide a value if all your conditions are FALSE, you can enter TRUE as a final condition, followed by a value.
=IFS(AND(G5>0, D6>0, G5>D6), G5-D6, AND(G5>0, D6<=0), E6 G5, AND(G5<=0, D6<=0, E6<F5), E6-F5, TRUE, 0)
CodePudding user response：
=IF(D2>89,"A",IF(D2>79,"B",IF(D2>69,"C",IF(D2>59,"D","F"))))
If the Test Score (in cell D2) is greater than 89, then the student gets an A
If the Test Score is greater than 79, then the student gets a B
If the Test Score is greater than 69, then the student gets a C
If the Test Score is greater than 59, then the student gets a D
Otherwise the student gets an F
CodePudding user response：
I hope the picture makes the problem clear now
CodePudding user response：
IFS checks for multiple conditions and returns the value of the first found TRUE. In your case no TRUE is found (G5 is not greater than D6) and returns N/A