MIS-Interview Series-Q8
MIS-Interview Series-Q5 Question was asked in MIS Interview. https://youtu.be/CiEq4Oi4HsI
Read moreTag: use of sumif
MIS-Interview Series-Q6
MIS-Interview Series-Q6 Question was asked in MIS Interview. https://youtu.be/jOYpdKY-GbY
Read moreIFERROR FUNCTION IN EXCEL
IFERROR Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR function to trap and handle errors in a formula. जब हम Excel में formula लगाते हैं तो कभी कभी error आता है, तो हम चाहते हैं कि अगर error आये तो उसके बदले, वो value आये जो हम mention करे , नहीं तो जो formula calculate कर रहा है, वो आये. When we type formula in […]
Read moreMake Watch in Excel VBA use of ONTIME Function
Making Watch In Excel Vba From below vba code & video you can learn how to make watch in excel vba use on ontime VBA Function. Click Here to Download File Sub makingwatch() Dim cancel As Boolean If Range(“k1”).Value = True Then Exit Sub Else snd = Second(Now) minute1 = Minute(Now) hour_a = Hour(Now) Sheet1.Shapes.Range(Array(“snd_2”)).Rotation = 6 * snd Sheet1.Shapes.Range(Array(“minute_1”)).Rotation = […]
Read moreSUMIF Function in Excel
SUMIF With the help of SUMIF Function in excel we get total value of all numbers in a range of cells based on one criteria. SUMIF की मदद से हम एक्सेल में, किसी range में से एक criteria के base पर, नंबर का टोटल निकलते है. For example in below image, we have item name & their value. उदाहरण के लिए, निचे के image में, item का नाम और valueहै. I want to sum of all value which is […]
Read more