Question about Computers & Internet

1 Answer

How can i use "IF" condition

How i can use "IF" condition more than 50 times in excle-2003

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 69 Answers

Only 7 IF statements can be nested in the same formula, so you'd have use 8+ cells. The syntax for IF is: =IF(logical_test,value_if_true,value_if_false)

So the maximum that can be in a single cell would look something like: =IF(logical_test,IF(logical_test,IF(logical_test,IF(logical_test,IF(logical_test,IF(logical_test,IF(logical_test,value_if_true,value_if_false),value_if_false),value_if_false),value_if_false),value_if_false),value_if_false),value_if_false)

Posted on Dec 31, 2008

  • Peter Sturniolo
    Peter Sturniolo Dec 31, 2008

    And you do not have to nest each IF statment in the value_if_true spot, you can also place them in the value_if_false spot.

×

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

What oil to put in 2003 1100 v.star


10w-50 in warmer conditions,10w-40 in cooler conditions. I like the full synthetics, but stay away from "energy conserving" oils. They contain additives that the clutch won't tolerate. API ratings of SL/CF,SJ,SG are safe. Good luck!

Jun 13, 2011 | 2003 Yamaha V Star 1100 Classic

1 Answer

How can I download ms office 2003. I min ms word ,excl, power point.


Unless you have a subscription to TechNet from Microsoft, this cannot be downloaded.

Jan 24, 2011 | Microsoft Office Professional Edition 2003...

1 Answer

I want to install excle 2007 & excle window Xp driver in my computer ,so that i can run my excle files easily


You need to purchase Microsoft Office to open Excel files.
There is a freeware program that is compatible with Microsoft Office.
Open Office can open and save Microsoft office programs. To download Open Office, please click on this link :-
http://www.openoffice.org/

Oct 31, 2010 | Microsoft Computers & Internet

1 Answer

Said my water pump was leaking and I needed to replace it. Is that normal for a 2003 camry with 81,000 miles? Car was running fine. I took it in for an oil change and fuel cleaning. Ended up costing me...


A lot of It depends on the condition of your coolant. or the percentage of coolant vs water.
50/50 is best. Too much coolant wont cool as good. Too much water and the lubrication and protection is lost. Then the waterpump goes out from lack of lubrication.
The water pump can also go out from the driving belt being too tight. Whether it is driven from the timing belt or a serpentine belt or a V belt.

Oct 20, 2009 | 2003 Toyota Camry

2 Answers

2003 Suburban---Heated leather seat problem


there may be a software issue, there is a reprogram for seat heater issues. Bulletin 05-08-50-008 may pertain to that, a AC DELCO Shop or the dealer can ck that and see if this bulletin applies.

Sep 29, 2009 | 2003 Chevrolet Suburban 1500

1 Answer

How much would replacing the hood and a headlight of a 2003 Hyundai Tiburon GT be


dear friend-here follows the prices requested by you.prices does not include fitting.
HOOD: R6575.59 EXCL.
HEAD LIGHT R3908.60 EXCL.

Jul 10, 2009 | 2003 Hyundai Tiburon

1 Answer

What is the height of britannia omaggio 90 cooker hood?


Hello,

Here are the dimensions that relate to your cooker hood. The measurements are in mm.

Width 980 front 578 rear
Depth 480
Minimum height 1015
Maximum height 1170
Main canopy height 750
(excl chimney)
Chimney section width 436 main body/340 sliding section
Chimney section depth 170
Mounting height 650 - 750

Regards
Alan Hood
ami-man
Width 960 front, 578 rear Depth 480 Minimum height 1015 Maximum height 1170 Main canopy height (excl. chimney) 750 Chimney section width 436 main body / 340 sliding section Chimney section depth 170 Mounting height 650 - 750
Width 960 front, 578 rear Depth 480 Minimum height 1015 Maximum height 1170 Main canopy height (excl. chimney) 750 Chimney section width 436 main body / 340 sliding section Chimney section depth 170 Mounting height 650 - 750 Width 960 front, 578 rear Depth 480 Minimum height 1015 Maximum height 1170 Main canopy height (excl. chimney) 750 Chimney section width 436 main body / 340 sliding section Chimney section depth 170 Mounting height 650 - 750 Width 960 front, 578 rear Depth 480 Minimum height 1015 Maximum height 1170 Main canopy height (excl. chimney) 750 Chimney section width 436 main body / 340 sliding section Chimney section depth 170 Mounting height 650 - 750

Jun 16, 2009 | Kitchen Ranges

1 Answer

Excle sheet


what error is coming while opening excel sheet??

May 15, 2009 | Computers & Internet

1 Answer

For software installing


Dear,
You can install application like that but not MS Office excle, word and power point.
Regards,
Rakesh Kumar

Apr 04, 2009 | Nokia N70 Cellular Phone

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

57 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

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

Answer questions

Manuals & User Guides

Loading...