Question about Microsoft Excel for PC

2 Answers

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 srz4 on

Ad

2 Answers

De Premor

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    New Friend:

    An expert that has 1 follower.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Contributor
  • 31 Answers

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

I want to write an Excel IF statement using only - 11_16_2012_10_24_08_am.png

Posted on Nov 16, 2012

Ad

reroute1991

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that got 5 achievements.

    New Friend:

    An expert that has 1 follower.

    Greenhorn:

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

  • Contributor
  • 52 Answers

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

Posted on Oct 19, 2012

  • 1 more comment 
  • fritzdorf
    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
    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!

×

Ad

2 Related Answers

Anonymous

  • 20 Answers

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

amstyl

Amstyl Polycarpe

  • 62 Answers

SOURCE: School Truancy Report Formula

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

Posted on Apr 03, 2009

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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

2 Answers

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

1 Answer

Download microsft excel 2003


Microsoft Excel is Part of the MS office, and unfortunately it is not free, however Open Office is free and you can do pretty much everything you can do with MS office, for excel they have something called Calc which is a spreadsheet program, it is free and it is good. But if you want MS excel you will have to buy it, downloading a cracked copy is not a good alternative they cause more problems than they solve.good luck

Jun 10, 2011 | Microsoft Excel 2003 (065-03992) for PC

2 Answers

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.

tally-export-screen-300x82.gif

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.

tally-export-ready-screen-300x81.gif

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

csv-file.gif

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

1 Answer

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.

tally-export-screen-300x82.gif

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.

tally-export-ready-screen-300x81.gif

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

csv-file.gif

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

1 Answer

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

1 Answer

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

1 Answer

How to formulate log function with excel


Here try this link

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

Nov 12, 2007 | Microsoft Excel for PC

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

150 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

k24674

Level 3 Expert

8092 Answers

Jax Planet
Jax Planet

Level 2 Expert

923 Answers

Brad Brown

Level 3 Expert

18666 Answers

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

Answer questions

Manuals & User Guides

Loading...