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

Ad

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

Ad

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.
Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

It stops counting steps at some point of the day


Hello, Anne -

Clarification: Your refrigerator stops counting steps?

Your question landed in the Fixya.com category for Refrigerators.

Or, is it a pedometer you have which stops counting steps? Or is it something else?

Whatever it is, to help you one will need to know _exactly_ what the item is - a refrigerator, a pedometer, some kind of exercise equipment - including the make and model, in order to provide you with relevant advice.

Best wishes.

Mar 02, 2018 | Refrigerators

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...

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?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

71 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2992 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

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

Answer questions

Manuals & User Guides

Loading...