| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage - How silly I feel asking this question !!!
Now I know this seems an easy question but I have completely lost it...
All I want to do is take a number and take away a percentage..ie: A B C 2.09 - 10% = 1.88 What should the formula for C be ??? Cell B is set as a percentage and can not be changed.... This should be so easy but I am finding it very hard...I think I am all excel'd out today... Please help Regards Mark |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage - How silly I feel asking this question !!!
B1-B1*C1
-- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "Mark Allen" wrote: Now I know this seems an easy question but I have completely lost it... All I want to do is take a number and take away a percentage..ie: A B C 2.09 - 10% = 1.88 What should the formula for C be ??? Cell B is set as a percentage and can not be changed.... This should be so easy but I am finding it very hard...I think I am all excel'd out today... Please help Regards Mark |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage - How silly I feel asking this question !!!
Sorry A1-A1*B1
-- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "Mark Allen" wrote: Now I know this seems an easy question but I have completely lost it... All I want to do is take a number and take away a percentage..ie: A B C 2.09 - 10% = 1.88 What should the formula for C be ??? Cell B is set as a percentage and can not be changed.... This should be so easy but I am finding it very hard...I think I am all excel'd out today... Please help Regards Mark |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage - How silly I feel asking this question !!!
Actually, the OP indicates that B is the percentage, and the result should be
in C, so assuming A has the initial value... C1: =A1-A1*B1 -- ** John C ** "Warren Easton" wrote: B1-B1*C1 -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "Mark Allen" wrote: Now I know this seems an easy question but I have completely lost it... All I want to do is take a number and take away a percentage..ie: A B C 2.09 - 10% = 1.88 What should the formula for C be ??? Cell B is set as a percentage and can not be changed.... This should be so easy but I am finding it very hard...I think I am all excel'd out today... Please help Regards Mark |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage - How silly I feel asking this question !!!
I Know the mistake I made was to test it in Columns B,C &D, should've paid
more attention. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "John C" wrote: Actually, the OP indicates that B is the percentage, and the result should be in C, so assuming A has the initial value... C1: =A1-A1*B1 -- ** John C ** "Warren Easton" wrote: B1-B1*C1 -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "Mark Allen" wrote: Now I know this seems an easy question but I have completely lost it... All I want to do is take a number and take away a percentage..ie: A B C 2.09 - 10% = 1.88 What should the formula for C be ??? Cell B is set as a percentage and can not be changed.... This should be so easy but I am finding it very hard...I think I am all excel'd out today... Please help Regards Mark |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage - How silly I feel asking this question !!!
Thanks all...I knew it was simple.....
"Mark Allen" wrote: Now I know this seems an easy question but I have completely lost it... All I want to do is take a number and take away a percentage..ie: A B C 2.09 - 10% = 1.88 What should the formula for C be ??? Cell B is set as a percentage and can not be changed.... This should be so easy but I am finding it very hard...I think I am all excel'd out today... Please help Regards Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Silly question | Excel Worksheet Functions | |||
| Silly question about using dates | Excel Discussion (Misc queries) | |||
| Silly Problem with Variable (2nd attempt) | Excel Discussion (Misc queries) | |||
| This is so silly... | Excel Worksheet Functions | |||
| Silly little annoyance | Setting up and Configuration of Excel | |||
Linear Mode
