Hi
What code can I use to calculate a percentage after the decimal number of a number in a cell?
For example: if the number is 145.87, I would like the cell to calculate 15% of 87 instead of 15% of 145.87.
Thanks
Hi
What code can I use to calculate a percentage after the decimal number of a number in a cell?
For example: if the number is 145.87, I would like the cell to calculate 15% of 87 instead of 15% of 145.87.
Thanks
With
A1: 145.87
B1: 15%
Try this:
or this:![]()
Please Login or Register to view this content.
Does that help?![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks