ATAR Notes: Forum
VCE Stuff => VCE Technology => VCE Mathematics/Science/Technology => VCE Subjects + Help => VCE Computing: Data Analytics => Topic started by: cobby on July 20, 2009, 10:26:52 pm
-
Hey guys,
What is the operator command when using excel to say "between 30 and 50"
I'm using the If( function, but i cant seem to get my desired result.
Thanks :)
-
>= 30 AND <= 50?
-
=(IF(AND(B1>=30,B1<=50),"true","false"))
Cell with the formula returns 'true' when B1 is between 30 and 50, otherwise it returns 'false'.
-
=(IF(AND(B1>=30,B1<=50),"true","false"))
Cell with the formula returns 'true' when B1 is between 30 and 50, otherwise it returns 'false'.
Thanks!
Thats pretty much the same as what i did,
I ended up with
=IF(F2<30,640,IF(AND(F2>=30,F2<=50),760,IF(F2>50,800)))
-
We haven't started excel yet :(
We are doing that as our last assessment.
-
lol i'm going to need some help with excel. started sac today. and gahh i hate the formulas. everyone says that its one of the easiest section of it applications, but i find it hardest so far. I guess the other sections are fairly easy though.
who else has started unit 4 outcome 1 sac?
-
lol i'm going to need some help with excel. started sac today. and gahh i hate the formulas. everyone says that its one of the easiest section of it applications, but i find it hardest so far. I guess the other sections are fairly easy though.
who else has started unit 4 outcome 1 sac?
We have our last class on design - task 1 tomorrow, and we begin development of task 1
-
do u actually have set time periods for each section? we just time manage our own. but then again we only have 7 year 12's doing i.t.
hope there is only a question on excel formula in the exam.
-
do u actually have set time periods for each section? we just time manage our own. but then again we only have 7 year 12's doing i.t.
hope there is only a question on excel formula in the exam.
Every section if time limited, it's supposed to be that way, make things easier as well in a way.
-
Hey guys,
What is the operator command when using excel to say "between 30 and 50"
I'm using the If( function, but i cant seem to get my desired result.
Thanks :)
Just use vlookup function for this one. In the parameters box, in each of the three cells, type 0, 30, 50.
EDIT: Just realised my VN account is 1 year old today. Time goes fast.
-
do u actually have set time periods for each section? we just time manage our own. but then again we only have 7 year 12's doing i.t.
hope there is only a question on excel formula in the exam.
Every section if time limited, it's supposed to be that way, make things easier as well in a way.
ah ok, i usually finish earier prob cause of this reason ahwell, not much different i guess. wish could take the sac home haha..
-
Hey guys,
What is the operator command when using excel to say "between 30 and 50"
I'm using the If( function, but i cant seem to get my desired result.
Thanks :)
Just use vlookup function for this one. In the parameters box, in each of the three cells, type 0, 30, 50.
EDIT: Just realised my VN account is 1 year old today. Time goes fast.
I daresay the VLOOKUP() function would not be as elegant in terms of display compared to the IF. Unless you have a need to change the 0, 30 and 50 values frequently, it's best to keep the logic in one place (cell).
-
need a formula which will:
e.g. if between 1-2 place 15% in the next column
if between 3-5 place 20% in the next column
or if between 5-10 place 50% in the next column
atm i have avoided this step and automatically put the percentage next to the data.. (note this is not the real information for the sac doing atm, but believe would be same process with different values.. is there a way or not?? in one formula.
also from that value that gives me.. e.g. 2000 10% give discount of $200of how do.. how do i get it to take away that value from another value. this ita book is useless. it gives me friggen nothing.. thanks for ur help if u cant help out thanks anyways, and ill have to google some more..
edited: i always get false answers lol... ahh ill eventually get my head around this.. worked out first bit thanks (thought i did but can only get it to either determine 15%. not the other percentages).. gah...
-
=IF(AND(,C6>=0,C6<=3),15%,0%)
sry for double posting.. but i can only get this formula.. this will only give me those precentages if the value is either 1 or 2.. how do i get a formula which will allow me to put more percentages for a value with 3-5 and more than 5 :S.. any idea? can i do this with an if statement, looks like i cant. is something like this possible?
-
=IF(AND(,C6>=0,C6<=3),15%,0%)
sry for double posting.. but i can only get this formula.. this will only give me those precentages if the value is either 1 or 2.. how do i get a formula which will allow me to put more percentages for a value with 3-5 and more than 5 :S.. any idea? can i do this with an if statement, looks like i cant. is something like this possible?
Create a separate table and use the Vlookup function,
Would be pretty hard to use the IF( function for multiple solutions as it can get very messy and hard to follow.
-
i have decided to skip it have worked out other formulas.. i dont actually think in sac it was required to put a formula in that section.. ahwell. ill look into vlookup functions. but sounds not cool lol.. thanks :) how is the progress on ur sac doing?
-
i have decided to skip it have worked out other formulas.. i dont actually think in sac it was required to put a formula in that section.. ahwell. ill look into vlookup functions. but sounds not cool lol.. thanks :) how is the progress on ur sac doing?
Vlookup is a lot easier once you get used to it
We are in our final period of development - task 1
Still around another 2 weeks to go haha
-
woop worked it out im pretty sure lol :) thanks.. amazing what happens when u put ur mind to things lol.. haha how many periods u got on it.. we get 8-10 :).. 4 down 4-6 to go. should have this done in time. just debating whether to do user documentation on microsoft word or frontpage.
how do u think your travelling? acing it.. and thank you again for your help :).
-
e.g. if between 1-2 place 15% in the next column
if between 3-5 place 20% in the next column
or if between 5-10 place 50% in the next column
=IF($C6<=0,"Out of range",IF($C6<=2,15%,IF($C6<=5,20%,IF($C6<=10,50%,"Out of range"))))
-
woop worked it out im pretty sure lol :) thanks.. amazing what happens when u put ur mind to things lol.. haha how many periods u got on it.. we get 8-10 :).. 4 down 4-6 to go. should have this done in time. just debating whether to do user documentation on microsoft word or frontpage.
how do u think your travelling? acing it.. and thank you again for your help :).
Can't remember how many periods exactly, im doing alright so far, user documentation will be the killer.
-
e.g. if between 1-2 place 15% in the next column
if between 3-5 place 20% in the next column
or if between 5-10 place 50% in the next column
=IF($C6<=0,"Out of range",IF($C6<=2,15%,IF($C6<=5,20%,IF($C6<=10,50%,"Out of range"))))
thankyou alot, i think ill stick to the vlookup formula, now comfortable with it. thankyou though :) prob come handy when comes to exam revision.
-
umm could anyone please shed some light on the mysterious HLOOKUP?
(E.g. provide an example for when it could be used)
-
umm could anyone please shed some light on the mysterious HLOOKUP?
(E.g. provide an example for when it could be used)
http://www.youtube.com/watch?v=4av_WHpVLtk
-
umm could anyone please shed some light on the mysterious HLOOKUP?
(E.g. provide an example for when it could be used)
http://www.youtube.com/watch?v=4av_WHpVLtk
cheers trrrrent
-
e.g. if between 1-2 place 15% in the next column
if between 3-5 place 20% in the next column
or if between 5-10 place 50% in the next column
=IF($C6<=0,"Out of range",IF($C6<=2,15%,IF($C6<=5,20%,IF($C6<=10,50%,"Out of range"))))
thankyou alot, i think ill stick to the vlookup formula, now comfortable with it. thankyou though :) prob come handy when comes to exam revision.
There's a chance you may lose marks in the exam if you use a nested IF() formula in the exam. VLOOKUP is much safer.
Excel formulas have always been a thorny area for IT:A students, so it's something I strongly suggest you brush over. Maybe I'll write up some question sheets if I find time to revise. When is the IT:A exam this year?
-
e.g. if between 1-2 place 15% in the next column
if between 3-5 place 20% in the next column
or if between 5-10 place 50% in the next column
=IF($C6<=0,"Out of range",IF($C6<=2,15%,IF($C6<=5,20%,IF($C6<=10,50%,"Out of range"))))
thankyou alot, i think ill stick to the vlookup formula, now comfortable with it. thankyou though :) prob come handy when comes to exam revision.
There's a chance you may lose marks in the exam if you use a nested IF() formula in the exam. VLOOKUP is much safer.
Excel formulas have always been a thorny area for IT:A students, so it's something I strongly suggest you brush over. Maybe I'll write up some question sheets if I find time to revise. When is the IT:A exam this year?
10th November 3-5.15pm
MY LAST EXAM WOOOOO