| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I use +-*/ in one formula
A1 B1 C1 D1
2 4 3 2 2 2 2 2 how do i add A1 *B1 -C1 and then / it by D1 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I use +-*/ in one formula
Please be more precise
What exactly do you want to add, what to subtract (from what?) and divide by what? -- Kind regards, Niek Otten "topjob" wrote in message ... | A1 B1 C1 D1 | 2 4 3 2 | 2 | 2 | 2 | 2 | how do i add A1 *B1 -C1 and then / it by D1 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I use +-*/ in one formula
"Niek Otten" wrote: Please be more precise What exactly do you want to add, what to subtract (from what?) and divide by what? -- Kind regards, Niek Otten "topjob" wrote in message ... | A1 B1 C1 D1 | 2 4 3 2 | 2 | 2 | 2 | 2 | how do i add A1:A5 then *B1then -C1 and then divide the answer by D1 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I use +-*/ in one formula
topjob, try =(A1*B1-C1)/D1 is that what you need?
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "topjob" wrote in message ... "Niek Otten" wrote: Please be more precise What exactly do you want to add, what to subtract (from what?) and divide by what? -- Kind regards, Niek Otten "topjob" wrote in message ... | A1 B1 C1 D1 | 2 4 3 2 | 2 | 2 | 2 | 2 | how do i add A1:A5 then *B1then -C1 and then divide the answer by D1 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I use +-*/ in one formula
=(A1*B1-C1)/D1
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "topjob" wrote in message ... A1 B1 C1 D1 2 4 3 2 2 2 2 2 how do i add A1 *B1 -C1 and then / it by D1 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I use +-*/ in one formula
topjob, missed you last part, try this instead =(SUM(A1:A5)*B1-C1)/D1
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Paul B" wrote in message ... topjob, try =(A1*B1-C1)/D1 is that what you need? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "topjob" wrote in message ... "Niek Otten" wrote: Please be more precise What exactly do you want to add, what to subtract (from what?) and divide by what? -- Kind regards, Niek Otten "topjob" wrote in message ... | A1 B1 C1 D1 | 2 4 3 2 | 2 | 2 | 2 | 2 | how do i add A1:A5 then *B1then -C1 and then divide the answer by D1 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I use +-*/ in one formula
YES, exactly what I needed Thankyou
"Paul B" wrote: topjob, missed you last part, try this instead =(SUM(A1:A5)*B1-C1)/D1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Paul B" wrote in message ... topjob, try =(A1*B1-C1)/D1 is that what you need? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "topjob" wrote in message ... "Niek Otten" wrote: Please be more precise What exactly do you want to add, what to subtract (from what?) and divide by what? -- Kind regards, Niek Otten "topjob" wrote in message ... | A1 B1 C1 D1 | 2 4 3 2 | 2 | 2 | 2 | 2 | how do i add A1:A5 then *B1then -C1 and then divide the answer by D1 |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I use +-*/ in one formula
Your welcome, thanks for the feedback
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "topjob" wrote in message ... YES, exactly what I needed Thankyou "Paul B" wrote: topjob, missed you last part, try this instead =(SUM(A1:A5)*B1-C1)/D1 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Paul B" wrote in message ... topjob, try =(A1*B1-C1)/D1 is that what you need? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "topjob" wrote in message ... "Niek Otten" wrote: Please be more precise What exactly do you want to add, what to subtract (from what?) and divide by what? -- Kind regards, Niek Otten "topjob" wrote in message ... | A1 B1 C1 D1 | 2 4 3 2 | 2 | 2 | 2 | 2 | how do i add A1:A5 then *B1then -C1 and then divide the answer by D1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
