Question about Microsoft Excel for PC

# I want to write an Excel IF statement using only mathematical operators (in another application). The Excel formulation is: =IF(MIN(Attempt1;Attempt2;Attempt3)=Attempt1;A1;IF(MIN(Attempt1;Attempt2;Attempt3)=Attempt2;A2;A3))

Posted by on

• 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

Let say you have table like this
' A ' B
---'--------------'-----------
1 ' First ' 2
2 ' Second ' 1
3 ' Third ' 3
On Cell C1 or other cell you like, try to type this formula
=IF(B1<B2;IF(B2<B3;A1;IF(B1<B3;A1;A3));IF(B2<B3;A2;A3))

That's all, just IF and math operand

Posted on Nov 16, 2012

• Level 1:

An expert who has achieved level 1.

MVP:

An expert that got 5 achievements.

Greenhorn:

A rookie expert who has answered 20 questions on their first day.

Night Owl:

An expert who has answered 10 or more questions between 12 midnight and 6am on the same day.

• Contributor

=IF(AND(Attempt1<Attempt2,Attempt1<Attempt3),A1,IF(AND(Attempt2<Attempt1,Attempt2<Attempt3),A2,A3))

Posted on Oct 19, 2012

• 1 more comment
• fritzdorf Oct 22, 2012

Thank you for your reply with the new formulation of my IF statement. Because it still contains IF and AND, unfortunately it won't work in the application I am using, where IF and AND are not available :-( Is there another way of writing it? perhaps a series of equations, or some kind of complex embedding?

• reroute1991 Oct 22, 2012

hmm would you be able to use something like " =VLOOKUP(min(ATTEMPT1,ATTEMP2,ATTEMP3), ...". Im sure there is a way but without knowing what software you are using, its hard to know the best way. what program are you trying to translate this to?

• fritzdorf Oct 23, 2012

It is a bespoke program that interrogates an SQL database. The programmers have not included the possibility for IFs and ANDs, but it could be possible for them to easily add VLOOKUP - great idea! I will suggest this to them. THANKS!

×

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).
goodluck!

Posted on Jan 02, 2017

SOURCE: LENGHTY IF STATEMENT

To find the second character in a string in A1 use =mid(A2,2,1)
To check if it is a number use =isnumber(value(mid(A2,2,1)))

I hope this helps to get past the part you are stuck on - not being familiar with your problem it's difficult to give you any more advice.

Posted on Mar 13, 2009

For the same exemple you can try this:
=COUNTIF(A1:A4,"=George Washington School")

Posted on Apr 03, 2009

×

my-video-file.mp4

×

## Related Questions:

### Do simple numerical mathematics like divide add multiply in database fields

Hi,
Thanks for using fixya , but could you be more specific , with the application or the software you are trying to use these functions in ,
eg, Microsoft excel or normal windows calculator .

Thanks
proton

Oct 11, 2008 | Computers & Internet

### What is the meaning of the mathimatical expression

n mathematics, an expression is a finite combination of symbols that are well-formed according to the rules applicable in the context at hand. Symbols can designate values (constants), variables, operations, relations, or can constitute punctuation or other syntactic entities.
Any "expression" that represents a numeric value. Example: 2+2=4 or x+7=10. Actually the examples above are equations, not expressions. Expressions do not have = signs. 7a and 4x are examples.
it is a mathematical statement e.g 7=6+1 THE WHOLE THING IS AN EQUATION but the 6+1 is a expression.You can only have expression is there is an = sign
Yes the 6 + 1 part is an expression. Once you have an = sign or any of the other inequality symbols (,...) it is no longer an expression but a full math sentence

Jun 22, 2011 | TOPICS Entertainment Elementary School...

### How can i export the data tally to excel

Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls

Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.

Hope this is helpful. Let us know if the issue is resolved.

*Rating and Comments are invited for this solution

Nov 24, 2010 | Tally T2245 Matrix Printer

### I HOW I EXPORT TALLY 7.2 DATA IN EXCEL FORMAT

Hi,

There are 2 ways to do it..

Step 1
You can export as text and import it back to excel using the text file you created.
Or
You can select HTML and give the file name as eg-XYZ.xls

Step 2

You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Step 3

Consider exporting day-book.Go to day book press export button or use shot cut key Alt+E. Exporting screen will displayed.

Press Back space on your keyboard. And select Format as ASCII (comma delimited). Now give output File Name as Daybook.csv, now select some other option you want to export from the bottom of the screen.

Press enter to accept screen. Day book is exported in to tally program folder. Check program folder for file daybook.csv,

Double click on it, the file will open in excel program. If you want it in excel work sheet file, use the option Saveas, and save it in Microsoft excel workbook (*.xls) format.

Hope this is helpful. Let us know if the issue is resolved.

*Rating and Comments are invited for this solution

Nov 10, 2010 | Tally T2245 Matrix Printer

### Add a excel format in tally

Sir,

What to Export ?
Tally has a facility to export its data to other applications like spreadsheets, word processing software and other database software. Export of data is provided mainly for summaries and statement reports like Trial Balance, Stock Summary, etc. You can export it to another company using Tally that will import it directly.

How to Export?
You can export all reports and statements. For this a separate export button is provided in right hand button bar. To do this go to any report e.g. day book you to export or any statement e.g. balance sheet. You would see export button on top right hand side on button bar. Press it and a screen would pop up with export related options.

The first option is format of data to be exported namely ASCII, HTML, SDF, and XML. Which ever application you are importing this data in would decide in which format you should export the data.
For statements like balance sheets and trial balance which we use to send and import file in word and excel etc. HTML format is good. We need minimum formatting in this format while using it in MS Word and MS Excel.
certain applications accept continuous data where we have defined field length. Then ASCII format is better.
For application which accept SDF and XML format these formats can be chosen.

Give a file name and the exported file is saved in the parent Tally directory on your computer. You can now use that file to import its contents into another program, send it as it is (say if it is HTML file) to a colleague or view it using a browser.

Thanks
Good Luck

Aug 14, 2009 | Adaptec Computers & Internet

### I want the all excel formulas

You will never find a fully comprehensive list anywhere because there are literally hundreds in the basic Excel application and thousands that can be added in as you go via macros. More are being added every time a new version of Office comes out.

But, the easiest way however to get a basic list of functions if your not printing is to hit the function button and simply scroll down the list. The syntax (an example of the method by which you should be formatting the formula) and a definition will list in the bottom of the dialog as you select each function.

That said, you are better solving individual problems as you learn Excel then trying to memorize all the functions themselves. Many, such as mathematical operations are common sense anyway.

Jun 19, 2009 | Microsoft Computers & Internet

### How to formulate log function with excel

http://support.microsoft.com/kb/214116

Nov 12, 2007 | Microsoft Excel for PC

#### Related Topics:

141 people viewed this question

Level 3 Expert

Level 3 Expert