Aug 09, 2017 03:15 AM
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.
Aug 09, 2017 05:46 AM
Don’t use ", that is making the number to be a string. Also, you don’t need the second IF.
Apr 28, 2020 11:30 PM
Same problem here, but I’m not wrapping numbers in “”.
May 01, 2020 12:00 AM
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 ?
May 01, 2020 02:28 PM
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()
.
May 01, 2020 11:12 PM
Spot on!
The & was making it a string.
I changed the formula to a Nested IF statement and the number formatting options returned.