Greater then and lesser then.

**Bharathms3** · 02-03-2012, 06:24 AM

Hi,

I have a numbers in say column c i need to find if greater than 40k and lesser then 60k then display as "3 months" in column d. Need ur help.

**TMS** · 02-03-2012, 06:50 AM

Cell D2: =IF(AND(C2>40000,C2<60000),"3 months","")

and copy down

Regards, TMS

**Bharathms3** · 02-03-2012, 07:07 AM

Hi,

Thanks for reply, may be i had being wrong in mentioning it pls see below i need to find answers as,
Name Total amount
a 20000 Need to find:
s 30000 If the value in a1:a7 greater than or equal to 40k but lesser then or equal to 60k then in column d it has to display as “3 months”
c 80000 If the value in a1:a7 greater than or equal to 60k but lesser then or equal to 1.20lk then in column d it has to display as “6 months”
d 90000 If the value in a1:a7 greater than or equal to 1.20lk but lesser then or equal to 2lk then in column d it has to display as “12 months”
f 60000
d 120000

**TMS** · 02-03-2012, 07:09 AM

I don't really understand the question. Please post a sample workbook.

Regards, TMS

**Bharathms3** · 02-03-2012, 07:32 AM

Unable to upload the sheet hope the below given is understandable,
Column A B C
Name Total Result
abc 60000
xyz 40000
def 80000
tty 200000
hhhi 120000
jjj 40000
kjj 10750

Need to find:
1. From column b1 to b8 if the value is >=40k but<=60k then it should show “avarege” in column c. If it is >=60 but <=1lk it should show as “good” in column c.

**Bharathms3** · 02-03-2012, 10:08 AM

test 2.xlsHi,

PFA is the example need your help to get this.

**TMS** · 02-03-2012, 10:39 AM

Still not sure exactly what you want, but this is one way with nested IFs

=IF(B2>=200000,"200k message?",IF(B2>=100000,"100k message?",IF(B2>=60000,"6 months",IF(B2>=40000,"3 months",""))))

Or, alternatively:

=LOOKUP(B2,{0,40000,60000,100000,200000},{">=0","3 months","6 months",">=100k",">=200k"})

Regards, TMS

**TMS** · 02-04-2012, 10:53 AM

Thanks for the rep.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save