Calculating Formula help

Casie

My goal is if total number of students is 0 then it should equal number of students then in Total students the formula will be total number of students minus number of students

S-Jacob

I think what you are asking for is this

=if([Total number of Students]@row=0,[Number of Students]@row,[Total Number of Students]@row-[Number of Students]@row)

Which is for columns A, B, and C
If B is 0, return A, else return A - B

S-Jacob

I think what you are asking for is this

=if([Total number of Students]@row=0,[Number of Students]@row,[Total Number of Students]@row-[Number of Students]@row)

Which is for columns A, B, and C
If B is 0, return A, else return A - B

Casie

THANK YOU SO MUCH!!