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 with whether it was on or over budget.
I am trying to write a formula where Total under 1500 populates the formula column with “On Budget”, Total over 1500 populates the formula column with “Over Budget”, and Total that is blank leaves the formula column blank. This is what I have written:
IF(Total<1500, “On Budget”, “Over Budget”), IF(Total=BLANK, BLANK)
But an error pops up that reads, “Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.” What am I doing wrong?