Formula Help
Need help with this formula:
I have a YES/NO category and if the answer is YES then I want to add all the columns listed below, if the answer is NO then I want the column to show $0.
=IF([Exterior Signage (YES/NO)]@row, YES, Exterior Survey Cost]@row + [Door Vinyl Cost]@row + [Privacy Screen Cost]@row + [Illuminated Channel Letters Cost]@row + [NON-Illuminated Channel Letters Cost]@row + [Monument Sign Cost]@row + [Post & Panel Cost]@row + [Parking Signs Cost]@row + 4025, IF([Exterior Signage (YES/NO)]@row, NO = 0)
Best Answer
-
=IF([Exterior Signage (YES/NO)]@row = "YES", ([Exterior Survey Cost]@row + [Door Vinyl Cost]@row + [Privacy Screen Cost]@row + [Illuminated Channel Letters Cost]@row + [NON-Illuminated Channel Letters Cost]@row + [Monument Sign Cost]@row + [Post & Panel Cost]@row + [Parking Signs Cost]@row + 4025), "$0")
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
You are already asking the IF question at the beginning, so you don't need to restate it. I think this should do the trick.
=IF([Exterior Signage (YES/NO)]@row = "YES", Exterior Survey Cost]@row + [Door Vinyl Cost]@row + [Privacy Screen Cost]@row + [Illuminated Channel Letters Cost]@row + [NON-Illuminated Channel Letters Cost]@row + [Monument Sign Cost]@row + [Post & Panel Cost]@row + [Parking Signs Cost]@row + 4025, 0)
-
you are almost there @Graham Cracker
=IF([Exterior Signage (YES/NO)]@row= "Yes",Sum(Exterior Survey Cost]@row,[Door Vinyl Cost]@row,[Privacy Screen Cost]@row,[Illuminated Channel Letters Cost]@row,[NON-Illuminated Channel Letters Cost]@row,[Monument Sign Cost]@row,[Post & Panel Cost]@row,[Parking Signs Cost]@row) + 4025,If([Exterior Signage (YES/NO)]@row= "NO",0))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Also if all those Columns are right next to each other you could do Sum([First Column on left]@row:[Last Column from left])
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
That is Very true. How ever if they do not have a yes or a no in the column it will also show a 0. If he wants it to remain blank until there is a yes or no then They would need the stacked If statements.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Hi David and Mark thank-you both for your quick responses. Unfortunately I keep getting the #UNPARSEABLE error with the formulas above. Any thoughts?
-
Are there any Entries that are not a numerical value?
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Nope. All are numbers.
-
would you mind sharing an image of what your working with?
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Can I share the sheet with you?
-
You can if you like. How ever if there is sensitive data on it I would not recommend sharing it with some one outside of your organization.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
I can remove the sensitive info. What is your email?
-
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
do you have Microsoft teams?
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
=IF([Exterior Signage (YES/NO)]@row = "YES", ([Exterior Survey Cost]@row + [Door Vinyl Cost]@row + [Privacy Screen Cost]@row + [Illuminated Channel Letters Cost]@row + [NON-Illuminated Channel Letters Cost]@row + [Monument Sign Cost]@row + [Post & Panel Cost]@row + [Parking Signs Cost]@row + 4025), "$0")
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
