Forum Discussion

Saurav_Kaura's avatar
Saurav_Kaura
Copper Contributor
Oct 30, 2021

'Else part' of if() is executed even if the condition mentioned is true.

Here i'm using if function to get value of age column. formula used is: if (f2<100,100-f2+14,f2-14) I am always getting answer from f2 -14 but the answer should come from 100-f2+14 Please help. H...
Formulas and Functions
  • Saurav_Kaura's avatar
    Saurav_Kaura
    Copper Contributor
    Oct 30, 2021

    Column f is formatted as general not text SergeiBaklan 

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Oct 31, 2021

      Saurav_Kaura Not sure I follow what you are trying to achieve, but is seems you calculate the age of cars counting from the year 2014. Correct?

       

      If so, use the formula provided by SergeiBaklan in F2 and copy down and change the formula in G2 to 

      =IF(F2 > 14,100-F2+14,14-F2)

      and copy down, the ages will be as you would expect them to be. 

       

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Oct 30, 2021

      Saurav_Kaura 

      It could be formatted as General, but MID() returns texts, thus values are considered as texts. You may check by ISTEXT() on cell from any empty one.

      • Saurav_Kaura's avatar
        Saurav_Kaura
        Copper Contributor
        Oct 31, 2021
        I have a doubt that how text format can be shown as general format in excel. Excel should show text format instead of general.

Resources