mardi 29 août 2017

If-Else ladder in Excel To sort data

I was doing R&D on Excel. And wanted to use If-else ladder in column of excel. Let's say I have a 2 columns and I calculated the difference between the two columns. Now, If the difference is between a range of (-5 to +5), if should display something or if Difference greater than 5, it should display something and for rest i.e. difference < -5, should display something else.
I tried and came up with this

=IF("H2>5",<something1>, IF("H2<5",<something2>))

How to put the range part in this if-else ladder? Also the above If else is not giving value but the result is turning out to be #VALUE.

Thanks for your help.

Aucun commentaire:

Enregistrer un commentaire