Question about Microsoft Excel for PC

1 Answer

How to stop an If count statemnt?

I am counting days on my first IF statement so i want to create a secont if statement that will stop the counting once the product has been collected.

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 38 Answers

One appraoch that comes to mind is to nest an AND function into your IF statement along the lines of IF(AND(Test1isTrue, NOT(ProductColleccted)), TrueAction, FalseAction)

Posted on May 02, 2015

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
the service is completely free 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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How can i create a new count for facebook


If you are finding it difficult to create a facebook account please have a read of https://www.facebook.com/help/570785306433644/?helpref=hc_fnav

If you still can't work it out get a family friend if possible to help you.

Jul 19, 2017 | Facebook Computers & Internet

1 Answer

Show syllables in words


Perl is a great language for this type of problem.

I recommend using Perl, and installing the Lingua::Phonology::Syllable module. Here is a working example:

use Lingua::Phonology;
use Lingua::Phonology::Syllable;
my $phono = Lingua::Phonology->new();
$phono->features->loadfile;
$phono->symbols->loadfile;
# Create a new Syllable object
my $syll = new Lingua::Phonology::Syllable;
# Create an input word
my @word = $phono->symbols->segment('s','h','e','p','h','e','r','d');
# Allow onset clusters and simple codas
$syll->set_complex_onset;
$syll->set_coda;
# Syllabify the word
$syll->syllabify(@word);
my $count = $syll->count_syll;
print "Count: $count\n"; # prints "Count: 2"
# @word now has features set to indicate a syllabification of
# <shep><herd>

Aug 27, 2014 | Computers & Internet

1 Answer

How syllable check


Perl is a great language for this type of problem.

I recommend using Perl, and installing the Lingua::Phonology::Syllable module. Here is a working example:

use Lingua::Phonology;
use Lingua::Phonology::Syllable;
my $phono = Lingua::Phonology->new();
$phono->features->loadfile;
$phono->symbols->loadfile;
# Create a new Syllable object
my $syll = new Lingua::Phonology::Syllable;
# Create an input word
my @word = $phono->symbols->segment('s','h','e','p','h','e','r','d');
# Allow onset clusters and simple codas
$syll->set_complex_onset;
$syll->set_coda;
# Syllabify the word
$syll->syllabify(@word);
my $count = $syll->count_syll;
print "Count: $count\n"; # prints "Count: 2"
# @word now has features set to indicate a syllabification of
# <shep><herd>

Aug 26, 2014 | Computers & Internet

1 Answer

Reset error m2


M2 -waste toner box need to empty.
Displayed to indicated that the Toner collect count of the consumables counter has reached the set count.To reset select Count in the Tech.Rep.mode and acces the Consumables screen.Select the count of toner collect and press the clear key to clear the count.Place the copier in the Tech.Rep.mode by pressing the following keys:Stop-0-Stop-1.

Dec 30, 2013 | Minolta EP4000/5000 CS/PRO Copier

1 Answer

I'm using d-link dwl-3200 ap ( three) Received Frame FCS Error Counts indicate a problem? ___________________________________________ WLAN 802.11G Traffic Statistics Throughput Transmit...


Transmitted Error Count 4734440

Ack Rcv failure Count 15269951


  • As per the above there are error on Transmitting the packet and also for receiving the acknowledge packet.
  • Please check whether any disturbance in the link
  • Each PPP packet has a checksum attached to ensure that the data being received is the data being sent. If the FCS of an incoming packet is incorrect, the packet is dropped and the HDLC FCS count is increased.
  • Another reason for seeing too many FCS errors may be that the remote end has stopped talking PPP.

Feb 27, 2011 | D-Link AirPremier DWL-3200AP 802.11g/b...

1 Answer

My Bauknecht dishwasher stopped working


Check all your breakers. Remove the wall plug, count to 20 and plug it back in and count to 5. This will reset it.

Jul 17, 2017 | Bauknecht 24 in. GSFP3988 Built-in...

1 Answer

I'm trying to create a control buttons for a flash CS3 movie and will also include another set of buttons that will take you to next scene and previous scenes.


ok, i tell u one thing.

one.fla

frame 1:

create a movieClip at 550x400 and give a instance name as 'movie_mc'

frame 2: Create two buttons as btn1,btn2.give instance as same.

frame 3: press F9 and Give 'stop();'
var count = 0

file1.fla

create animation

file2.fla

create animation

one.fla

next button script is

on(press)
{
count = count+1;
movieclipinstancename.loadMovie("file"+count);
}

previous button

on(press)
{
count = count-1;
movieclipinstancename.loadMovie("file"+count);
}


May 31, 2009 | Adobe Flash® CS3 Professional Full Version...

2 Answers

Printing syntax


'declare the variables
Dim Connection
Dim ConnString
Dim Recordset
Dim SQL

'define the connection string, specify database driver
ConnString="DRIVER={SQL Server};SERVER=yourServername;UID=yourUsername;" & _
"PWD=yourPassword;DATABASE=yourDatabasename"

'declare the SQL statement that will query the database
SQL = "SELECT * FROM TABLE_NAME"

'create an instance of the ADO connection and recordset objects
Set Connection = Server.CreateObject("ADODB.Connection")
Set Recordset = Server.CreateObject("ADODB.Recordset")

'Open the connection to the database

Connection.Open ConnString

'Open the recordset object executing the SQL statement and return records
Recordset.Open SQL,Connection

'first of all determine whether there are any records
If Recordset.EOF Then
Response.Write("No records returned.")
Else
'if there are records then loop through the fields
Do While NOT Recordset.Eof
Response.write Recordset("FIRST_FIELD_NAME")
Response.write Recordset("SECOND_FIELD_NAME")
Response.write Recordset("THIRD_FIELD_NAME")
Response.write "<br>"
Recordset.MoveNext
Loop
End If


'close the connection and recordset objects to free up resources
Recordset.Close
Set Recordset=nothing
Connection.Close
Set Connection=nothing

May 16, 2009 | Microsoft Windows Vista Ultimate Edition

1 Answer

Creating a formula


go to the field with the number of day formula and modify the formula just add to it this *8. The result will be in hrs.
Assuming a holiday uses 8 hrs of pay. It sounds like everyone starts with 25 holiday X 8 hrs or 200 total hours,

Jun 18, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft Excel for PC Logo

70 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2658 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18389 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...