Showing a minimum amount if 2 things arent met help

Im trying to get a daily minimum field where if the sum of certain cells dont reach a specified amount then its that amount, but if it does it subtracts it until it gets to 0, right now it's giving me -numbers. also i only want to do this on parent/child rows that have a date field populated already. i then want to multiply that number by 3%

=IF(ISBLANK(Date33), 0, IF(SUM([# of Pages]34:[# of Pages]36) < 25, "25", SUM([# of Pages]34:[# of Pages]36)*0.03)))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!