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
-
Are you able to provide a screenshot with some sample data manually entered?
From what I can gather without more clarification, it seems like this should work for you...
=IF(ISBLANK(Date33), 0, IF(SUM([# of Pages]34:[# of Pages]36) < 25, 25, SUM([# of Pages]34:[# of Pages]36)) * 0.03
Answers
-
this is the equation that it going into the negative.
=SUMIF(ISBLANK(Date39), 0, SUM((25 - [# of Pages]40 + [# of Pages]41 + [# of Pages]42 * 0.03)))
-
Are you able to provide a screenshot with some sample data manually entered?
From what I can gather without more clarification, it seems like this should work for you...
=IF(ISBLANK(Date33), 0, IF(SUM([# of Pages]34:[# of Pages]36) < 25, 25, SUM([# of Pages]34:[# of Pages]36)) * 0.03
-
that worked thank you so much @Paul Newcome
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!