Help

If Statements not generating number values for later formulas?

Solved
Jump to Solution
856 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Smote
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all! I just started doing taxes as a small business and I figured I’d make an airtable chart to keep track of all the different tax rates in different counties. However, what I’m running into is this:

When I go to formatting I get the response: Your result type is not a number or a date. Formatting options are currently only available if your result type is a number or a date.

Here is my formula:

IF(
    SEARCH("Online", {Location}),
    "0%",
    IF(
        SEARCH("Wake", {Location}),
        "2%",
        IF(
            SEARCH("Durham", {Location}),
            "2.25%"
        )
    )
)

I’ve tried both with and without the % symbol.

To be fair, the return in that column works fine but I can’t then make a later formula using those values because it doesn’t recognize them as numbers. Here’s a screenshot of the table

Screenshot 2022-03-31 082447

I saw in another thread that maybe doing a separate tax rates table would help, but I am unsure how to set it so that if I click “Durham” on my Location it would apply the Durham Tax Rates to the rest of the line. However, that method might be more useful in the long run since I could easily change one number on one spreadsheet rather than updating each individual column’s IF statement.

Any assistance is appreciated! I haven’t done a ton of formula building with airtable and find it a bit more difficult than sheets/excel.

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Remove the quotation marks and the percentage symbols from your numbers.

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Remove the quotation marks and the percentage symbols from your numbers.

Smote
5 - Automation Enthusiast
5 - Automation Enthusiast

… are you kidding me :rofl:

That worked perfectly! I was using a copy-paste from someone else’s IF statements and just assumed the quotations had to be there! Thank you!