Enjoy life...

Posts

Showing posts from 2020

Show all

Pivot OLAP functions

Create Pivot table Check Add to data model Click on OLAP tools Select Convert to formulas Done !

5% TCS on foreign transfer, but claimable on ITR

https://tradingqna.com/t/5-tax-on-foreign-transfers-from-october-1st/89603/2

Remove ‘ALT+ENTER Line Breaks Without VBA in MS Excel cells

You can use this formula to remove these line breaks with spaces. =SUBSTITUTE(A1,CHAR(10)," ")

import java.util.Scanner; public class SipCalculator { public static void main(String[] args) { // Create a scanner object to get user input Scanner sc = new Scanner(System.in); // Get the principal amount, interest rate, and number of years from the user System.out.println("Enter the monthly investment amount:"); double p = sc.nextDouble(); System.out.println("Enter the annual interest rate (in percentage):"); double r = sc.nextDouble(); System.out.println("Enter the number of years:"); int y = sc.nextInt(); // Close the scanner object sc.close(); // Calculate the monthly interest rate and the number of payments double i = r / 12 / 100; int n = y * 12; // Calculate the maturity value using the formula double m = p * (Math.pow(1 + i, n) - 1) / i * (1 + i); // Display the results System.out.println("The total amount invested is: " + p * n); System.out.println("The estimated return is: " + (m - p * n)); System.out.println("The maturity value is: " + m); } }