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
That's all, just IF and math operand
Posted on Nov 16, 2012
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
Tips for a great answer:
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
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Usually answered in minutes!
Step 2: Please assign your manual to a product: