Question about Computers & Internet
I want to reference a cell and test for multiple outcomes and return a number. I was trying to do it using nested if functions in excel 2000 but it gets too confusing.
I am trying to write a simple estimating program. I have 10000 staples to a case. I want to put .34 in cell A1 if R31<=133 and .67 in cell A1 if R31>133 then 1 in cell A1 if R31>266 and so on 1.34 if R31>400 etc. Up to whatever the limit is. And return a 0 if nothing or 0 is in R31. Or perhaps there is a better way?
As i can understand you are using the nested if wrongly, you can use it in the macro as given below. I have written this code in a macro and checked it, the results were as you are demanding.
put the following code in a macro and exicute it to get the desired results.
If Range("R31").Value <= 133 Then
Range("A1").Value = 0.34
ElseIf Range("R31").Value > 133 And Range("R31").Value <= 266 Then
Range("A1").Value = 0.67
ElseIf Range("R31").Value > 266 And Range("R31").Value <= 400 Then
Range("A1").Value = 1
ElseIf Range("R31").Value > 400 Then
Range("A1").Value = 1.34
Range("A1").Value = 0
Hope your problem will be resolved, if you still have any problem, you can ask or consult without any hesitation.
Posted on May 25, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
New users get to try the service completely Free afterwhich it costs $6 per call and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jul 30, 2014 | Microsoft Excel 2010
Oct 31, 2008 | Computers & Internet
Apr 25, 2014 | Microsoft Excel for PC
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Jun 09, 2010 | Sun Java Programming Language (cdj-275)
Apr 01, 2010 | Microsoft Windows XP Professional
Jul 29, 2009 | Computers & Internet
Feb 17, 2009 | Microsoft Excel for PC
Dec 09, 2008 | Microsoft Excel for PC
Jan 25, 2008 | Computers & Internet
111 people viewed this question
Usually answered in minutes!