Easy Formula Help
Moving on to my next application. We keep track of Adobe subscriptions so we can charge the proper departments. I have the table and such setup, I just need help with the Yearly Cost formula. I ha...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIF([field 1], 1,0)
+IF([field 2], 2,0)
+IF([field 3], 5,0)
Note that in each if statement it ends with a zero because you don't want the result of the effort to be null because that will wreck the total, and make it blank.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Mark,
That's closer to an excel formula than I thought. Did you possibly leave out the "condition"? Should it be more like...
IF([field 1], true, 1,0)
+IF([field 2], true, 2,0)
+IF([field 3], true, 5,0)
Just thinking there isn't a condition to be met in your version.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------