Calculating Formula help
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
Tags:
Best Answer

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
Answers

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 
THANK YOU SO MUCH!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 352 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 36 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!