Question about Microsoft Office Standard for PC

1 Answer

If function in excel

I have data in colomn with some numbers

from 810001 to 810500 = TINU
from 810501 to 851000 = MINU
from 851001 to 852000 = PINU

A B
810001
850245
854215
856741
863521
874510
WHICH FUNCTION I USE WETWEEN GREATER THAN, XXXX, LESS THAN XXXX = TINU /MINU/PINU IS SHOWING IN COLOMN B

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
  • 36 Answers

Where data is in Column A1, place this in B1

=IF(AND(A1>=810001,A1<=810500),"TINU",IF(AND(A1>=810501,A1<=851000),"MINU",IF(AND(A1>=851001,A1<=852000),"PINU","")))

Posted on Jan 09, 2009

  • Andrew Podner Jan 09, 2009

    looks like the last bit got chopped off, starting from MINU.......

    "MINU",IF(AND(A1>=851001,A1<=852000),"PINU","")))

×

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:

4 Answers

Cannot open file. Error message reads: Excel cannot open


Use Excel Repair Toolbox is efficient corrupt XLSX file repair software, suitable for all data recovery activities, applied to Microsoft Excel documents.

For more: https://www.xlsxrepairtoolbox.com/

Aug 03, 2015 | Microsoft Excel for PC

2 Answers

Excel Error Message.What can I do to stop this error?


A corrupt excel spreadsheet can be repaired by using Open and Repair technique. It is a built-in repair function that opens a corrupt excel file forcefully.
*OpenMS Excel >pressCtrl+O >locate corrupt excel spreadsheet and select it.
*Click on the arrow shown besideOpenbutton>selectOpen and Repair.
It will take just a few seconds to be completed and selected file will be opened, if possible.

Or if this doesn't work, one may take help of a third-party

For example Excel Fix Toolbox
https://www.fixtoolbox.com/excelfix.html

Apr 24, 2015 | Microsoft Office Excel 2007

1 Answer

I have a project going in my company. I want psion teklogic to automatically send the scanned data into Excel. Please help me in understanding how can I do this ?


you may need an ocr to excel software converter
http://www.simpleocr.com/OCR_to_Excel
in excel you would have a work book that you put the resulting scan into as an excel format. Then you have another workbook that is referenced to the workbook and particular cell with part number
then you would have a workbook with a list of cells part number and pdf files .
then lookup function would take part number and use it to lookup from the reference list.

Mar 28, 2014 | Psion Teklogix 7535 G1 WiFi PDA w/Long...

2 Answers

What is excel


Hi,

Microsoft Excel is a commercial spreadsheet application . It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.

Regards,
Shrey

Jun 04, 2011 | Microsoft Excel for PC

2 Answers

What is the function of Microsoft excel?


Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

1 Answer

I have sound, no pic. I can bring up minu


you must take this unit in for servicing at a service center for a failing television tuner. The unit has lost control of the video signal.The reason it sound like the tuner is you still have a screen and switching controls functioning. The service center can test unit and determine if the tuner has failed or some supporting components. You can call Insignia customer support for service at this telephone number 1-877-467-4289. You can also go to their website for customer support at www.insignia-products.com. I hope this information helps you with your problem.

Mar 04, 2009 | Insignia LCDTV26 26 in. Television

1 Answer

VLOOKUP FORMULA PROBLEM


VLOOKUP(A1,Sheet2A2:B20,2,FALSE)

The assumption here is A1 in Sheet 1 is the cell you want to reference, This cell can be pasted - Any problems let me know.

Jan 21, 2009 | Microsoft Excel for PC

1 Answer

How to uppend the numbers in micro soft excel.


There is no function or formula to append data in Excel. Depending on how you want to add the data to existing data in excel. This would have to be done manually or by writing a vba script.

Jan 18, 2009 | Computers & Internet

1 Answer

Microsoft excel(data analysing)


Microsoft Excel is an application used for building spreadsheets. It has many built in calculation and graphics tools. Some people use it to track expenses while other use it to graph numbers for charting process. As far as data analyzing it all depends on the data. Whether is sales figures or budget information. It all can be done inside of excel using it built in formulas and functions.

Sep 22, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

59 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18377 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...