Skip to main content

Result type is not a number or a date

E

I have added a formula IF({Töö sisu} = “Hooldus”, “17”,IF({Töö sisu} = “Transport”, “7”, “”)) and the result is not a number so I cant format it nor can I use sum function. I need the 7 to be 7€ so I can count the sum.

    5 replies

    E

    Don’t use ", that is making the number to be a string. Also, you don’t need the second IF.

    K
    Avi_Doe
    2 people like this
    • K
      Kate_Boshammer
    • Avi_Doe
      Avi_Doe
    Dean_Arnold
    • Dean_Arnold
    • Inspiring
    • 44 replies
    • April 29, 2020

    Same problem here, but I’m not wrapping numbers in “”.

    Dean_Arnold

    Here’s my formula:
    IF(ItemPriceUSD>0,ItemPriceUSD1)&IF(ItemPriceCNY>0,ItemPriceCNYExRateCNY)

    There are no " in my formula, and all the fields used in the formula are numbers.

    I need access to number formatting for the formulated number, but I still keep getting the “Your result type is not a number” message.

    Is this a bug or a feature?
    @Elias_Gomez_Sainz ?

    E
    Dean_Arnold wrote:

    Here’s my formula:
    IF(ItemPriceUSD>0,ItemPriceUSD1)&IF(ItemPriceCNY>0,ItemPriceCNYExRateCNY)

    There are no " in my formula, and all the fields used in the formula are numbers.

    I need access to number formatting for the formulated number, but I still keep getting the “Your result type is not a number” message.

    Is this a bug or a feature?
    @Elias_Gomez_Sainz ?


    The & is making it a string, I think. You want to concatenate 2 prices? Or you want to include 2 conditions? You can use an AND() to use several conditions in an IF().

    Dean_Arnold

    Spot on!

    The & was making it a string.

    I changed the formula to a Nested IF statement and the number formatting options returned.

    Reply


    Most helpful members this week

    Terms & Conditions