LinkBack URL
About LinkBacks
Hi All,
I would like to give a cell a number (498) and have 9 different percents taken out of that number, showing me each percent (4%, 19.9).
Hi All,
I would like to give a cell a number (498) and have 9 different percents taken out of that number, showing me each percent (4%, 19.9).
You get better help if you add an excel example without confidentional information.
Please also add the desired (expected) result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
If you cel was A3
for 4%
=IF($A$3>0,$A$3*0.04,"")
then just copy formula to other cells and change 0.04 to whatever value you want
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks