Hi,
I am doing one simple calculation i.e adding interest to principal amount.
say for example 10% of 100, the result should be 110.
I would like to know is there any function in excel which will do this calculation in one cell only without using different cell for getting the result.
To get this calculation currently I am using three cells
One for Entering Principla Amount
Second for Calculating the Interest
and Third one for adding Principal amt and Interest amount to get the final result.
thank you
Assuming that A2 contains the principle, and B2 contians the interest rate, try...
=A2*(1+B2)
Or, if you prefer, if A2 contains the principle, you could use the following formula instead...
=A2*110%
Hope this helps!
You can utilize the "copy" and "paste special" funcions to accomplish this.
Enter your multiplier into a blank cell somewhere onthe sheet (i.e. 1.05). Now copy that cell then highlight the entire range that you want to multiply by this factor. Then choose Paste Special and check "Mulitply" under the Operation section of the dialog box.
This should muiply each number in the range you specified by the multiplier and leave the resulting numbers in the original cells.
thanks a tonOriginally Posted by Domenic
thats the 2nd option, i was searching for.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks