Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
Hi I'm really stuck and not sure where I'm going wrong.
If I put £100 in A1 and I put 40% in B1 and I want to take 40% away from £100 then I thought the formulas in c1 would be =A1-B1 but it doesn't seem to work. so what can I do to show A1 minus 40%? Its doing my head in and I'm probably doing something really stupid. Please help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
=a1-(a1*b1)
hope that helps susan On Jul 22, 8:23*am, onebraincell wrote: Hi I'm really stuck and not sure where I'm going wrong. If I put £100 in A1 and I put 40% in B1 and I want to take 40% away from £100 then I thought the formulas in c1 would be =A1-B1 but it doesn't seem to work. so what can I do to show A1 minus 40%? Its doing my head in and I'm probably doing something really stupid. Please help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
In say, C1: =A1*(1-B1)
-- Max Singapore http://savefile.com/projects/236895 Downloads:16,000 Files:354 Subscribers:53 xdemechanik --- "onebraincell" wrote: Hi I'm really stuck and not sure where I'm going wrong. If I put £100 in A1 and I put 40% in B1 and I want to take 40% away from £100 then I thought the formulas in c1 would be =A1-B1 but it doesn't seem to work. so what can I do to show A1 minus 40%? Its doing my head in and I'm probably doing something really stupid. Please help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
Thank you so much but could you explain why that formula. Sorry would just
like to know how in future. Many many thanks "Max" wrote: In say, C1: =A1*(1-B1) -- Max Singapore http://savefile.com/projects/236895 Downloads:16,000 Files:354 Subscribers:53 xdemechanik --- "onebraincell" wrote: Hi I'm really stuck and not sure where I'm going wrong. If I put £100 in A1 and I put 40% in B1 and I want to take 40% away from £100 then I thought the formulas in c1 would be =A1-B1 but it doesn't seem to work. so what can I do to show A1 minus 40%? Its doing my head in and I'm probably doing something really stupid. Please help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas
Since B1 contains the percentage to be taken away, hence the remaining
percentage will be: 1-B1 (this is the same as writing: 100%-B1) The remaining value to be calculated is hence: A1 x (1-B1) or: =A1*(1-B1) Take a moment to press the "Yes" button below -- Max Singapore http://savefile.com/projects/236895 Downloads:16,200 Files:354 Subscribers:53 xdemechanik --- "onebraincell" wrote: Thank you so much but could you explain why that formula. Sorry would just like to know how in future. Many many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |