IFS logical tests order problem :(

Hello I'm having trouble figuring out what order to put my formula so it works properly.

I have test scores in cell B2, C2. I want to calculate the difference in percent from test 1 to test 2 or if score one is zero then show the test 2 score in points.

I believe the possible value combinations for the cells are:

Blank, Blank
Score,Blank
Zero,Score
Zero,Zero
Zero,Blank
Score,Zero
Score,Score

I made the following formula to handle the calculation from score one to score 2 but it does not work properly, I suspect there is a problem with the order of the logical tests but I do not know. I also do not know which order will make all of the value combinations calculate properly or if its even possible.

Also the scores are recorded as percentages.

=IFS(AND(B2<>"",C2=""),"",AND(B2<>"",C2<>""),(C2-B2)/B2,AND(B2<>"",C2<>""),(C2-B2)/B2,AND(B2=0,C2=""),"",AND(B2=0,C2<>""),OriginalScoreinpoints&" Points",AND(B2=0,C2=0),"0",AND(B2="",C2=""),"")

If someone more knowledgeable can provide some insight into how to make this work under all the aforementioned conditions it would be greatly appreciated!

	B	C
2
3		0%
4		60%
5	0%
6	0%	0%
7	0%	60%
8	60%
9	60%	0%
10	60%	80%

What should be the result in each case?

If I'm reading your formula correctly:

Please Login or Register  to view this content.

The IFS function is only available with Office365, so I used standard nested IF statements. I believe the IFS version (untested) would be:

Please Login or Register  to view this content.

You're most welcome, thank you for the rep!

Wait hold up lol it does not work. Sorry I have a neurological health condition and I am having a lot of trouble concentrating =/.

Ill upload a sample spreadsheet

For cell F2, the IF version returns [B2=0,C2=0]="0". Is this incorrect?
(NOTE: your post #8 formula is actually from row 4, correct?)

So what is the correct return for [B2=0,C2=0]?

This returns the NUMBER 0, rather than the text character "0". Cell formatting will add the "%", yielding 0.00%:

Please Login or Register  to view this content.

The N()function returns the numeric value of a cell. If the cell contains TEXT, including "", it returns 0. It allows one test to catch 0 OR "".
BTW, I noticed your change to the point clause. I was going to ask...
Anything else?