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
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. 

 

Resources