Previous in Forum: Rogue Anti-Spyware Can Infest Your Computer   Next in Forum: PCs without CPUs and Hard Disks
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
11 comments
Rate Comments: Nested
flyinghigh
Power-User
United States - Member - New Member

Join Date: May 2008
Location: Arizona
Posts: 355
Good Answers: 4

Excel Formula

11/12/2008 3:18 PM

Good afternoon. I'm trying to write a formula in Excel. I want to say if x=/>7, then y=1; but if x=/<6, then y=0.8. How can I do that? Thx.
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Good Answers:

These comments received enough positive votes to make them "good answers".

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
3
Anonymous Poster
#1

Re: Excel Formula.

11/12/2008 3:59 PM

Let's say your value is in cell a1:

=IF(A1>=7,1, IF(A1<=6,0.8,"inbetween"))

If the value is between 6 and 7, you will get a value of "inbetween"

What They Did
Register to Reply Good Answer (Score 3)
Go to Next Good Answer
flyinghigh
Power-User
United States - Member - New Member

Join Date: May 2008
Location: Arizona
Posts: 355
Good Answers: 4
#2
In reply to #1

Re: Excel Formula.

11/12/2008 6:54 PM

Guest, you the man! Thx a lot!
Register to Reply
flyinghigh
Power-User
United States - Member - New Member

Join Date: May 2008
Location: Arizona
Posts: 355
Good Answers: 4
#3
In reply to #1

Re: Excel Formula.

11/12/2008 7:24 PM

Hey Guest, are you still around? Now I need to write a formula that says =IF(A1<1.7, THEN OK). Can you help? Thx.
Register to Reply
3
BabyGuinness
Power-User
Ireland - Member - New Member Engineering Fields - Energy Engineering - New Member

Join Date: Aug 2007
Location: Northern Ireland
Posts: 197
Good Answers: 17
#4
In reply to #3

Re: Excel Formula.

11/12/2008 11:57 PM

Hi there

What you are asking is very basic and Excel tells you how anyway. If you tye

=if(

into a cell, Excel will display the syntax required.

You formula would read

=if(a1<1.7,"OK")

Hint: always type in lower case; when Excel recognises the command or cell reference, it automatically puts these in upper case (IF, A1 etc). You can then easily spot syntax errors in long formulas as they will still be in lower case.

__________________
 I love deadlines; I love the whooshing sound they make as they pass by. - Douglas Adams
Register to Reply Good Answer (Score 3)
No more Good Answers. Go to first "Almost" Good Answer
flyinghigh
Power-User
United States - Member - New Member

Join Date: May 2008
Location: Arizona
Posts: 355
Good Answers: 4
#5
In reply to #4

Re: Excel Formula.

11/13/2008 9:27 AM

Good morning BabyGuinness. Thx for educating a dummy like me.
Register to Reply
HarryBurt
Power-User
Hobbies - Fishing - New Member Popular Science - Evolution - New Member United States - Member - New Member Engineering Fields - Mechanical Engineering - New Member

Join Date: Jul 2007
Location: Cleveland, OH
Posts: 445
Good Answers: 10
#6

Re: Excel Formula

11/13/2008 9:33 AM

One of the icons on the Standard toolbar is an italic fx. Clicking on that will give you a list of al the functions in Excel. Select IF and you'll get a form to fill in. It has three lines: test (x=>7), if true (y=1) and if false (y=.8) Looking at your question, what if x=6.5?

__________________
 "Just a little off the top" - Marie Antoinette
Register to Reply Score 1 for Good Answer
No more "Almost" Good Answers.
flyinghigh
Power-User
United States - Member - New Member

Join Date: May 2008
Location: Arizona
Posts: 355
Good Answers: 4
#7
In reply to #6

Re: Excel Formula

11/13/2008 9:55 AM

Good morning Professor HarryBurt. Thx for enlightening me. This old sliderule guy really appreciates it.

I have since realized that loophole and changed it to read if x =,>1.7, then y; and if x < 1.7, then z. Thx for your excellent post.
Register to Reply
HarryBurt
Power-User
Hobbies - Fishing - New Member Popular Science - Evolution - New Member United States - Member - New Member Engineering Fields - Mechanical Engineering - New Member

Join Date: Jul 2007
Location: Cleveland, OH
Posts: 445
Good Answers: 10
#9
In reply to #7

Re: Excel Formula

11/14/2008 8:10 AM

Glad to help. BTW, I have my old Log-Log Duplex in my desk drawer. It's mahogany, with teflon slides.

__________________
 "Just a little off the top" - Marie Antoinette
Register to Reply
flyinghigh
Power-User
United States - Member - New Member

Join Date: May 2008
Location: Arizona
Posts: 355
Good Answers: 4
#10
In reply to #9

Re: Excel Formula

11/14/2008 10:44 AM

Man, that was the Hewlett-Packard of the day!
Register to Reply
HarryBurt
Power-User
Hobbies - Fishing - New Member Popular Science - Evolution - New Member United States - Member - New Member Engineering Fields - Mechanical Engineering - New Member

Join Date: Jul 2007
Location: Cleveland, OH
Posts: 445
Good Answers: 10
#11
In reply to #10

Re: Excel Formula

11/14/2008 11:37 AM

Agreed. I can't believe how many impressive engineering projects were done with one. I didn't get any serious computer assistance until 1982, and worked on some pretty big projects before that. 30 ft dia tunnel boring machine, for instance.

__________________
 "Just a little off the top" - Marie Antoinette
Register to Reply
Jim at GodwinPumps
Power-User

Join Date: Aug 2007
Location: Bridgeport, New Jersey, USA
Posts: 109
Good Answers: 6
#8

Re: Excel Formula

11/13/2008 10:24 AM

Sorry - post duplicated previous response....

__________________
 "For a successful technology, reality must take precedence over public relations, for Nature can not be fooled." - Richard Feynman
Register to Reply
Register to Reply
Have a Different Question?
11 comments

Good Answers:

These comments received enough positive votes to make them "good answers".

"Almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, vote them!
Copy to Clipboard

Users who posted comments:

Anonymous Poster (1); BabyGuinness (1); flyinghigh (5); HarryBurt (3); Jim at GodwinPumps (1)

Previous in Forum: Rogue Anti-Spyware Can Infest Your Computer   Next in Forum: PCs without CPUs and Hard Disks

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (83 right now)
Show Members
Advertisement