Login

Welcome, Guest. Please login or register.

October 12, 2025, 01:25:48 pm

Author Topic: Excel Operators  (Read 5885 times)  Share 

0 Members and 1 Guest are viewing this topic.

cobby

  • Victorian
  • Part of the furniture
  • *****
  • Posts: 1437
  • Respect: +7
Excel Operators
« on: July 20, 2009, 10:26:52 pm »
0
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 :)
2008 - Economics
2009 - Maths Methods CAS
          English
          I.T Apps
          P.E

mark_alec

  • Victorian
  • Part of the furniture
  • *****
  • Posts: 1173
  • Respect: +30
Re: Excel Operators
« Reply #1 on: July 21, 2009, 07:44:47 am »
0
>= 30 AND <= 50?

Wst

  • Victorian
  • Forum Regular
  • **
  • Posts: 72
  • Respect: +1
Re: Excel Operators
« Reply #2 on: July 22, 2009, 12:02:55 am »
0
=(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'.
« Last Edit: July 22, 2009, 12:05:47 am by Wst »
Bachelor of Business Information Systems (IBL Stream)
~Wst~

cobby

  • Victorian
  • Part of the furniture
  • *****
  • Posts: 1437
  • Respect: +7
Re: Excel Operators
« Reply #3 on: July 22, 2009, 07:54:01 am »
0
=(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)))
2008 - Economics
2009 - Maths Methods CAS
          English
          I.T Apps
          P.E

Vadnal

  • Victorian
  • Forum Obsessive
  • ***
  • Posts: 234
  • Respect: +2
Re: Excel Operators
« Reply #4 on: July 27, 2009, 08:07:23 pm »
0
We haven't started excel yet :(
We are doing that as our last assessment.
2009: IT Applications
2010: Chemistry | Literature | Methods (CAS) | Physical Education | Health and Human Development
ATAR required: 86, ATAR aim: 90+

billz1508

  • Victorian
  • Trendsetter
  • **
  • Posts: 130
  • Respect: +41
Re: Excel Operators
« Reply #5 on: July 30, 2009, 05:37:52 pm »
0
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?

cobby

  • Victorian
  • Part of the furniture
  • *****
  • Posts: 1437
  • Respect: +7
Re: Excel Operators
« Reply #6 on: July 30, 2009, 06:46:27 pm »
0
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
2008 - Economics
2009 - Maths Methods CAS
          English
          I.T Apps
          P.E

billz1508

  • Victorian
  • Trendsetter
  • **
  • Posts: 130
  • Respect: +41
Re: Excel Operators
« Reply #7 on: July 30, 2009, 07:18:48 pm »
0
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.

cobby

  • Victorian
  • Part of the furniture
  • *****
  • Posts: 1437
  • Respect: +7
Re: Excel Operators
« Reply #8 on: July 30, 2009, 07:20:19 pm »
0
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.
2008 - Economics
2009 - Maths Methods CAS
          English
          I.T Apps
          P.E

danieltennis

  • Guest
Re: Excel Operators
« Reply #9 on: July 30, 2009, 07:55:01 pm »
0
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.
« Last Edit: July 30, 2009, 07:57:16 pm by daniel. »

billz1508

  • Victorian
  • Trendsetter
  • **
  • Posts: 130
  • Respect: +41
Re: Excel Operators
« Reply #10 on: July 30, 2009, 08:27:31 pm »
0
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..

excal

  • VN Security
  • Victorian
  • ATAR Notes Legend
  • *******
  • Posts: 3490
  • Über-Geek
  • Respect: +21
Re: Excel Operators
« Reply #11 on: August 02, 2009, 01:04:14 am »
0
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).
excal (VCE 05/06) BBIS(IBL) GradCertSc(Statistics) MBBS(Hons) GCertClinUS -- current Master of Medicine candidate
Former Global Moderator

billz1508

  • Victorian
  • Trendsetter
  • **
  • Posts: 130
  • Respect: +41
Re: Excel Operators
« Reply #12 on: August 04, 2009, 09:19:30 pm »
0
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...
« Last Edit: August 04, 2009, 10:07:03 pm by billz1508 »

billz1508

  • Victorian
  • Trendsetter
  • **
  • Posts: 130
  • Respect: +41
Re: Excel Operators
« Reply #13 on: August 04, 2009, 10:13:14 pm »
0
=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?

cobby

  • Victorian
  • Part of the furniture
  • *****
  • Posts: 1437
  • Respect: +7
Re: Excel Operators
« Reply #14 on: August 04, 2009, 10:24:38 pm »
0
=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.
2008 - Economics
2009 - Maths Methods CAS
          English
          I.T Apps
          P.E