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
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.
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
Tips for a great answer:
Jun 28, 2014 | Computers & Internet
Oct 11, 2008 | Computers & Internet
Jun 22, 2011 | TOPICS Entertainment Elementary School...
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 Excel@ 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
Jul 23, 2013 | Microsoft Excel for PC
141 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: