Question about Microsoft Excel for PC
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
=IF(AND(Attempt1<Attempt2,Attempt1<Attempt3),A1,IF(AND(Attempt2<Attempt1,Attempt2<Attempt3),A2,A3))
Posted on Oct 19, 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?
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?
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!
×
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
SOURCE: School Truancy Report Formula
For the same exemple you can try this:
=COUNTIF(A1:A4,"=George Washington School")
Posted on Apr 03, 2009
Jun 22, 2011 | TOPICS Entertainment Elementary School...
Oct 11, 2008 | Computers & Internet
Jun 10, 2011 | Microsoft Excel 2003 (065-03992) for PC
Nov 24, 2010 | Tally T2245 Matrix Printer
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
Jun 21, 2010 | Vivendi [email protected] Mathematics Study Skills...
Aug 14, 2009 | Adaptec Computers & Internet
Jun 19, 2009 | Microsoft Computers & Internet
Nov 12, 2007 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
150 views
Usually answered in minutes!
×