combining of formula

[vikash]

in one column i have values which i want to classify depending which value they lie between i am able to do it separately but in a single column. file attached

 

[NARAYANK991]

Hi ,

I am not clear on what you want to do , but concatenating the two results is done by concatenating the two formulae , as in :

=IF(AND(C5>=1,C5<5),"a","b") & IF(AND(C5>=5,C5<10),"c","d")

Enter this is any one cell , say F5 , and copy down.

If you can explain exactly what you want to do , a better formula can be developed.

Narayan

 

[vikash]

Hi ,

I am not clear on what you want to do , but concatenating the two results is done by concatenating the two formulae , as in :

") & =IF(AND(C5>=1,C5<5),"a","bIF(AND(C5>=5,C5<10),"c","d")

Enter this is any one cell , say F5 , and copy down.

If you can explain exactly what you want to do , a better formula can be developed.

Narayan

I have to classify the value given. All the values between 1 to 5 should be coded as "a" and between 5 to 10 should be "c". However i am not able to put the formula at one go and i am doing it in two different column. i want it in one column.
for example
7-c
10-c
2-a
5-a

 

[NARAYANK991]

Hi ,

In that case , try this :

=IF(AND(C5>=1,C5<5),"a",IF(AND(C5>=5,C5<10),"c","b"))

Narayan

 

[Harshad Maloo]

You should try this Formula,

=IF(AND(10-C5>=5,10-C5<10),"a",IF(AND(10-C5>=0,10-C5<=5),"c"))

 

[shrivallabha]

Maybe LOOKUP table?
=LOOKUP(C5,{1,5},{"a","c"})

 

[CA Rohit]

I have tried using vlookup approximate match function + text function to get your desired result. You can tweak your assumptions in order to get required answer.

Hope this solves your problem

Rohit