This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I am trying to create an event expense tracking table. In one column, I want to know if an event is on or over budget. I have a column, “Total”, where I will record the amount the event cost. Ideally I would then like the next column to be populated ...
Jeremy_Oglesby:
IF(Total<1500, “On Budget”, IF(Total>1500, “Over Budget”, IF(Total=BLANK(),BLANK())))
I followed your advice about creating a budget field. But when I type a number into the budget field and keep the total field blank, it is st...
