Excel 2007 : If condition

[sriramakella23]

Hi,
I need an excel formula..
I want the value in second column for every 10 CSAs in the first there should be one TL
and for every 15 CSAs there should be one QTL.

Please anyone could help me on this.

Thank you
Sriram Akella

[pike]

Hi sriramakella23,
Welcome to the forum.
Can you edit the attached work book to show before and after results as its a little hard to follow what is required.

[sriramakella23]

ok let me put it in this way.
for 1 to 10 CSAs there should be one TL and from 10 to 20 CSAs there should be two TLs.likewise it should increase.
and for QTL for every 15 CSAs there shoiuld be 1 QTL and ffrom 15 to 30 CSAs there should be two QTLs..
Hope this is clear.
Thank you.

[pike]

oh.. maybe...
=REPT("TL ",ROUNDUP(C2/10,0)) and
=REPT("QTL ",ROUNDUP(C2/15,0))

[sriramakella23]

Hi,
Thanks for the reply.. i need numbers like <10 it should display 1 TL, <=10 and >=20 CSAs it should be display 2 , >=20 and <=30 3 for TL and for QTL <=15 1 QTL and >=15 and <=30 2 QTLs etc.

Thanks

[sriramakella23]

IF((B2-MOD(B2,10))/10=0,1,(B2-MOD(B2,10))/10). i have tried using this formula. but i need for 11 CSA one TL.
Thanks

[pike]

Hi,
Thanks for the reply.. i need numbers like <10 it should display 1 TL, <=10 and >=20 CSAs it should be display 2 , >=20 and <=30 3 for TL and for QTL <=15 1 QTL and >=15 and <=30 2 QTLs etc.

Thanks

which one, >=20 can only be 2 or 3 not both?

[sriramakella23]

Ok for 1 to 10 CSA 1 TL, 10 to 20 CSAs 2 TLs, 20 to 30 CSAs 3 TLs and so on.
and for QTL 1 to 15 CSAs 1 QTL, 15 to 30 CSAs 2 QTLs, 30 to 45 3 QTLS and so on..
Thanks

[teylyn]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

[pike]

Hey sriramakella23,
The request to change your title must be addressed before we can continue. Can you please go to your first post and click "edit" then "go advanced" and change your title to something about the specific forumlae/function and then save. It will make search for answers easier for other with a similar puzzle.

[sriramakella23]

Hi,
I have given the output in TL & QTL rows. I need an if condition which will generate automatically the values.
Thanks

[pike]

hmmm..
I dont think the figure are right in the table results for the value of 30 with 15 base
=ROUNDUP(B2/10,0)+IF(MOD(B2,10)=0,1,0)
=ROUNDUP(B2/15,0)+IF(MOD(B2,15)=0,1,0)

[sriramakella23]

Hi,
Thanx alot. it worked.
Sriram

[pike]

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

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