-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
function excel-2013
-
T
Data need to split 1 hour time intervel
<colgroup><col span="5"></colgroup><tbody> <colgroup><col style="width:48pt" width="64" span="5"> </colgroup><tbody> I need to split data, i am having 24 hours data. the time interval also included in that columns. for example, input...- Thoufeeq
- Thread
- excel & macro excel & vba formula & macro function excel-2013 sql excel
- Replies: 2
- Forum: Excel Questions
-
K
[MOS] Microsoft Office Specialts Exam 77-420: Excel 2013 Help!!
Hi everyone, Today i gave my MOS Exam 77-420 : Excel 2013. i scored 980/1000. overall the exam was easy. i got 100% in all objectives except 90% in 'Applying Formulas & Functions'. I know where i did wrong. But i still can't figure out how to solve that problem because of which i couldn't score...- k_mahajan
- Thread
- certification formula help function excel-2013 mos urgent excel help
- Replies: 10
- Forum: Excel Questions
-
D
Any better solution than awkward nested if?
I wrote a nested if to add a description based on a column's value, like this: =IF(A2<0,"No Activity", IF(A2>180,"No Activity More than 180 days", IF(A2>150,"Within 180",IF(A2>120,"Within 150",IF(A2>90,"Within 120","Within 90"))))) It's a little awkward, I wonder if there's any other neat...- dayanday
- Thread
- function excel-2013
- Replies: 3
- Forum: Excel Questions
