Excel Operators

[billz1508]

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?

[cobby]

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

[billz1508]

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 .

[Mao]

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

Code: [Select]

=IF($C6<=0,"Out of range",IF($C6<=2,15%,IF($C6<=5,20%,IF($C6<=10,50%,"Out of range"))))


[cobby]

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.

[billz1508]

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

Code: [Select]

=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.

[methodsboy]

umm could anyone please shed some light on the mysterious HLOOKUP?
(E.g. provide an example for when it could be used)

[cobby]

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

[methodsboy]

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

[excal]

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

Code: [Select]

=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?

[cobby]

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

Code: [Select]

=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