Forum Discussion
UserID303932
Mar 20, 2019Copper Contributor
IFS function + roundup, sum, and right
I can't get less than and more than to work how I'd like it to in an IFS function. =IFS((RIGHT(ROUNDUP(SUM(((G6*0.55)+G6)+((G6*0.55)+G6)/11),2),4))<=5,CEILING(SUM(((G6*0.55)+G6)+((G6*0.55)+G6)/11)...
SergeiBaklan
Mar 21, 2019MVP
UserID303932 , if you'd like to have only 5 or 9 you may use
=(G6>5)*4+5