If Then Else??Cat Indic Apple Banana Coconut Durian
Ripe (R) 10 30 50 70
Unripe (U) 60 40 20 10
Seeded (SD) 70 0 0 80
Seedless(SL) 0 70 70 0
If I have a 1 column for either Fruits (Apple, Banana, Coconut or Durian)and another on Indicators (R, U, SD, SL), at the row that I have maybe listing Apple & Unripe, I want to extract the quantity (60), how do I go about with the If Then Else function?
Hi,
Am Mon, 19 Mar 2012 07:11:36 GMT schrieb khoo nora:
> Cat Indic Apple Banana Coconut Durian
> Ripe (R) 10 30 50 70
> Unripe (U) 60 40 20 10
> Seeded (SD) 70 0 0 80
> Seedless(SL) 0 70 70 0
...
if else if...hello all!!
any reason why this should not work correctly ? ;)))
tx !!!
If aWS.Range("M52").Value = True Then
aWS.Range("M80").Value = 5
Else
If aWS.Range("M51").Value = True Then
aWS.Range("M80").Value = 4
Else
If aWS.Range("M50").Value = True Then
aWS.Range("M80").Value = 3
Else
If aWS.Range("M49").Value = True Then
aWS.Range("M80").Value = 2
Else
If aWS.Range("M48").Value = True Then
aWS.Range("M80").Value = 1
End If
End If
End If
End If
End If
Hi,
Well it&...
Someone else's job, someone else's templateComplete novice at Publisher, must use previous employee's template & text
for new job. Text in Word document. Am I merging, cutting/pasting to text
box, importing, or something else? Please help; desperate.
Create a text box, right-click, click change text, click text file, browse to
your Word document.
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"Ali" <Ali@discussions.microsoft.com> wrote in message
news:F00ADD8A-0715-43C8-8975-007D40E34D72@microsoft.com...
> Complete novice at Publisher, must u...
Else If
Is there a function which will check in a specified cell for a number
(should be from 1-10) and return a specific value based what number it
found in that cell?
Ex.
IF(A1=1,"text1")
IF(A1=2,"text2")
IF(A1=3,"text3")
IF(A1=4,"text4")
IF(A1=5,"text5")
IF(A1=6,"text6")
IF(A1=7,"text7")
IF(A1=8,"text8")
etc...
--
mallets123
------------------------------------------------------------------------
mallets123's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25090
View this thread: http://...
if then else statementOn my report I have a field that I need help with. I have written an =If
statement to try and capture all of the variables, but it is too long, so now
I need to write the same expression in code. Here is what I have in my =If
statement (which resides in the Detail area of the Report):
=IIf([costcode]="013210" And
[costtype]="05320",[txtActualCost]/[txtCraftLabAct],IIf([costcode]="020110"
And
[costtype]="05320",[txtActualCost]/[txtFirewatchLabAct],IIf([costcode]="064201"
And
[costtype]="05320",[txtActualCost]/[txtC...
something elsehi
can we please talk about some news headlines here please
thanks
Hi, Sabian.
> can we please talk about some news headlines here please
Of course not. This newsgroup is dedicated to Microsoft Access database
discussions and always has been. If you don't want to discuss this topic,
you are welcome to subscribe to different newsgroups.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/e...
IF Then ElseHi,
Can someone point out to me what I have wrong with this IF statement. No
matter what I change or where I place commas I still get a Syntax Error. I
have a Form with one text box for an input number and a command button to run
my query. I want to put in this IF statement in the query. It is suppose to
do this. When a number is put into the text box the query checks for match in
the dwFirstNumber field. If there is not any then to look in the
dwSecondNumber field and then the dwThirdNumber for matches. This is what I
entered on the criteria line of my query:
If(([Forms]![tbl...
If,Then, ElseCould someone please help me with the correct syntax for the "IF, Then: Else:
" command
--
Alan S
"Alansa59" <Alansa59@discussions.microsoft.com> wrote in message
news:979ED94B-6E2C-4D89-9417-07C02D84CCE8@microsoft.com...
> Could someone please help me with the correct syntax for the "IF, Then:
> Else:
> " command
> --
> Alan S
Sure. Let's say you want to do something if a file doesn't exist. It could
be coded like this
If Dir(MyFileName) = "" Then
'This part executes when the above condition ...
Anyone else get charged TWICE?Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
I just bought 8 from this website. Got charged twice. Anyone else have this experience? One for a little over 160 bucks and one for 149?? Don't even know who to get a hold of.
Which website?
If you double-click the "Submit" button on a vendor website, you will indeed
get charged twice, because you have submitted two orders.
Cheers
On 28/03/10 3:07 PM, in article 59bb615b.-1@webcrossing.JaKIaxP2ac0,
"jayson@officeformac.com" <jayson@officeformac.com> wrote:
> Version: 2008 Ope...
If Then Else?In the detail portion of my report, I have a field that is Est As % of
Labour. The calculation I need is dependant on if a cost code and a cost
type is this, then perform this calculation. Example:
If [costcode]="020110" and [costype]="05320, take the EstimatedCost (of
this costcode/costtype) and divide by EstimatedCost of costcode=013210 and
costtype=05320.
another:
If [costcode]="036110" and [costype]="05511, take the EstimatedCost (of
this costcode/costtype) and divide by EstimatedCost of costcode=031101 and
costtype=05110
Any sugges...
If Then ElseI don't understand why this code not work
Dim StrPr1 As String
Dim StrPr2 As String
Dim StrPr3 As String
StrPr1 = "123"
StrPr2 = "1234"
StrPr3 = "12345"
If Me.Text0.Value = StrPr1 Or StrPr2 Or StrPr3 Then
'Statment
Else
'Statment
End If
Thank you Fredg
"fredg" <fgutkind@example.invalid> wrote in message
news:yzg8hd64pr2i$.ox32wavwm7zy$.dlg@40tude.net...
> On Fri, 22 Feb 2008 11:40:55 -0800, a wrote:
>
>> I don't understand why this code not work
>>
>> Dim StrPr1 As String
>>
>> Di...
If-Then-Else StatementIt is not executing my If-Then-Else statement.
It seems the only statement being executed is: Cells(Row, Col).Value =
Range("K" & Row) and I only want it to do that if the condition is
true, and put a 0 in each cell in the range if it is false. Can someone
please look at my code and help me to get it to execute the
If-Then-Else statement. Thank you. Updated code as follows:
Sub Fill()
Dim TestDate As Date
Dim Col As Integer
Dim Row As Long
For Col = 13 To 29
For Row = 7 To 63
With TestDate = DateAdd("m", Range(&q...
Someone else's job, someone else's template #2Thank you for the earlier help. Unfortunately, I need more, please.
--I am using Publisher 2003; there are 4 master page templates that I am
supposed to use. The first is for the title page, which I think that I can
manage (maybe); the "Master B" is two-page with header and footer design in
place; the "Master C" is one-page with same (perhaps this is the back cover
-which will contain the organization's contact info.?)
--I took your advice; it placed the document (6-7 pages) on the first page
of Master B only; and you could only see the first page, even in Prin...
Anyone else?Does anyone else have any suggestions for this dillema that I find myself in?
Thanks in advance, MC
The only thing that I can gather from your post is that you need to use the
spelling checker. The grammar could be better too.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Michaelcip" <Michaelcip@discussions.microsoft.com> wrote in message
news:B6EF553F-9538-44EE-BC74-127081A880F4@microsoft.com...
> Doe...
If else when formulahi,
how if i want to compare a data entered by user in a column if it is matched
with the DB created in excel?
eg, if user key in 'A' in column G4, column H4 should display whichever data
that matches the user key in 'A' from DB (column C) , all the matched 'A'
alpabet from the DB column C will display in column H4.
Thanks.
regards,
moon
If I understand correctly, you want to enter a value in G4. Everything that
matches this in column C should show in column H. Everything else in column
H should be blank. If so, enter this in H4 then use fill fill handle to dr...
IF THEN ELSE CODING missing a stepI am using the following lines of code and I can not figure out why it is
completely skipping the VBNO DOCMD. Is this worded incorrectly?
Function Another_Record()
MSGBOX "Do you wish to do another LRU update?", vbYesNo, "LRU UPDATE"
If vbYes Then
DoCmd.GoToControl "Serial Number"
Else
DoCmd.Close acForm, "EDIT CDS LRU ASSET"
End If
End Function
Try
if (Msgbox("blah bla",vbYesNo,"Title") = vbYes) then
else
end if
"Curtis" <Curtis@discussions.microsoft.com> wrote in ...
dictionaries and elseHi, I have recently bought a MacBook and would like to ask you whether
the dictionaries installed in Office software vary between countries
(if I buy Office in the US, for example, what dictionaries does it come
with, and if I do the same in Switzerland, same question). And I would
also appreciate your general comments on Office 2004 and Intel-Macs.
Thanks.
Depends on what you mean by dictionaries.
If you mean things that offer definitions, all versions of Office 2004,
whether English or other languages, only offer English language definitions
for English words.
If you mean the ability to...
What else to checkI am not able to send outgoing mail from exchange 2003 sp1.
I have read every thred on this board and have tried Telnet and SMTPdiag.
Manually they both work. The SMTPdiag gives me an error on the SOA records,
but then goes on to communicate with the mail server.
DNS seems to be setup correctly. Internet works fine.
Could someone PLEASE give me a direction to look in ...
can you send manually via telnet to port 25? If not, are you setup for a
smarthost that is not responding? Can you post the exact message you receive
in Outlook after attempting to send? Or does it sit in the queue?...
What else I miss?Hi all,
I enabled all global settings for mobile on the exchange server 2003.
Configure Microsoft-SErver-ActiveSync to require SSL in IIS of Front end
server since the FE has SSL certificate. Configure
MIcrosoft-Server-ActiveSync to use basic authentication in FE server and use
integrated authentication on the BE servers. Then, on the device, configure
the server IP is the FE's public IP. But, somehow, it did not synronize?
Can anyhone point out what steps I missed? Do I have to enable form-based
authentication on the FE server to get it work?
On Tue, 8 Aug 2006 07:48:01 -07...
If Then ElsePrivate Sub SiScode_AfterUpdate()
If Me.Indicator.Value <> 0 Then _
GoTo LeaveSub Else _
MsgBox "You MUST select whether you are adding to VMI or billing
CD before proceeding", , "PAY ATTENTION!"
End If ' This is "END IF #1"
If (Me.Dirty = True) Then
' Clear it
Me.Undo
End If
Me.SiScode.SetFocus
LeaveSub:
End If ' This is "END IF #2"
End Sub
I originally made the mistake of placing the END IF #2 and got a
compile error referencing block if issue. Searched the group and felt
that I found the ans...
how do I setup my Outlook profile on someone else's desktop?I have recently been employed by a new company. I am working at the prior
staff person's desktop. I have been issued a new outlook user id. My
problem is that since I am using someone else desktop, I don't know how to
receive e-mails to my outlook profile, and how to incorporate or forward my
predecessors e-mails with my profile.
Need advise.
Ivan
ibvalle <ibvalle@discussions.microsoft.com> wrote:
> I have recently been employed by a new company. I am working at the
> prior staff person's desktop. I have been issued a new outlook user
> id. My problem i...
IF without ELSEIs it possible to use the IF function without an else clause?
I have a cells that automatically update for an external source, I'd
like to validate that the value is a number before passing it on via
DDE.
I.e.
A1 = 100
B1 = IF(ISNUMBER(A1),A1,do nothing)
--
B1 = IF(ISNUMBER(A1),A1,B1) causes a circular reference.
Thanks
have you tried
IF(ISNUMBER(A1),A1,"")
--
Don Guillett
SalesAid Software
donaldb@281.com
<avian2@gmail.com> wrote in message
news:1125340321.415562.279710@f14g2000cwb.googlegroups.com...
> Is it possible to use the IF function without an else cla...
COUNTIF or something else?I am trying to use COUNTIF function where the range might vary. For instance,
I want to know how many yes I have in column D and E together, with the
condition that C will be only equal with 1.
C D E
1
1 Yes
1 Yes
1
2 Yes
2
2 Yes
3 Yes
3 Yes
3 Yes
3
{=COUNTIF(IF($C$1:$C$11=1,$D$1:$E$11,0),"yes”)} should be 2.
Thanks for your help.
Hi
This should do it:
=SUMPRODUCT(--(C1:C11=1),--(D1:D11="yes"))+SUMPRODUCT(--(C1:C11=1),--(E1:E11="yes"))
Regards,
Per
"Count-Adi" <Count-Adi@discussions.microsoft.com> sk...
Budget Category for "Everything Else"So I recently got around to setting up a budget in
Money. When I was finished, Money kindly let me know
that I will have $x available to save or spend at the end
of each month.
What I'd like to do is now track how much of that $x I'm
spending on all other non-budgeted categories each
month. For many categories it's hard to budget exactly
how much I'm going to spend each month (new suit vs new
LCD monitor vs new coffee table vs Red Sox playoff
tickets - hard to say). I'd like to keep track of how
much I'm spending in total across all these unbudgeted
catego...
If Then Else?? #21 A B C D E F G H I
2 Country MSIA SPORE HK China Japan Thai Viet
3
4 Base 0.10 0.95 0.13 0.13 0.13 0.12 0.10
(1-Bucket + 1-Crate)
5 1-Bucket 0.04 0.04 0.04 0.04 0.04 0.12 0.04
6 1-Crate 0.09 0.10 0.09 0.09 0.09 0.09 0.09
7
8 Raisin R 0.01 0.01 0.02 0.05 0.03 0.01 0.01
9 Grape G 0.17 0.19 0.15 0.16 0.24 0.08 0.12
10
11 Unripe UC1 0.07 0.07 0.08 0.07 0.07 0.03 0.05
12 Unripe UC2 1.00 1.03 1.56 0.95 0.95 0.45 0.67
13 Unripe UC3 0.29 0.30 0.45 0.27 0.27 0.13 0.19
14 Ripe RC1 0.57 0.59 0.69 0.54 0.54 0.25 0.38
15 Ripe RC2 0.39 0.40 0....