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.
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.
Cell D2: =IF(AND(C2>40000,C2<60000),"3 months","")
and copy down
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
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
I don't really understand the question. Please post a sample workbook.
Regards, TMS
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.
test 2.xlsHi,
PFA is the example need your help to get this.
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks