PC Review


Reply
Thread Tools Rate Thread

How the conditional formulas work

 
 
derekul
Guest
Posts: n/a
 
      25th Nov 2008
i need a formula for to calculate price and parts so the total price is at
the botom of it

i have the xls file if anyone needs it
 
Reply With Quote
 
 
 
 
Sheeloo
Guest
Posts: n/a
 
      25th Nov 2008

Send it to me with details of what you want...

Click on my name to get my id...

"derekul" wrote:

> i need a formula for to calculate price and parts so the total price is at
> the botom of it
>
> i have the xls file if anyone needs it

 
Reply With Quote
 
Shane Devenshire
Guest
Posts: n/a
 
      25th Nov 2008
Hi,

We need more info, you don't need to post the whole file but show us a
sample and whate you want.

Cheers,
Shane Devenshire

"derekul" wrote:

> i need a formula for to calculate price and parts so the total price is at
> the botom of it
>
> i have the xls file if anyone needs it

 
Reply With Quote
 
derekul
Guest
Posts: n/a
 
      25th Nov 2008
like Super-Flex® Track - 36" Section (5 pk) cost $24.25
how many x 5
total pice = $121.25

but the total pice has to be at the botom of the how many colum E

"Shane Devenshire" wrote:

> Hi,
>
> We need more info, you don't need to post the whole file but show us a
> sample and whate you want.
>
> Cheers,
> Shane Devenshire
>
> "derekul" wrote:
>
> > i need a formula for to calculate price and parts so the total price is at
> > the botom of it
> >
> > i have the xls file if anyone needs it

 
Reply With Quote
 
Shane Devenshire
Guest
Posts: n/a
 
      26th Nov 2008
So where are the cost - 24.25 located (cell address please A1?) where are
the How many number 5 located E15? where is the total price E16? Is the
text "Super-Flex® Track - 36" Section (5 pk) cost " in the same cell as the
$24.25? Is the "x" in the same cell as the 5.

For example, if 24.25 is in E1, 5 is in E2 then the formula in E3 is =E1*E2.
This is what you asked, but ...?

Cheers,
Shane Devenshire

"derekul" wrote:

> like Super-Flex® Track - 36" Section (5 pk) cost $24.25
> how many x 5
> total pice = $121.25
>
> but the total pice has to be at the botom of the how many colum E
>
> "Shane Devenshire" wrote:
>
> > Hi,
> >
> > We need more info, you don't need to post the whole file but show us a
> > sample and whate you want.
> >
> > Cheers,
> > Shane Devenshire
> >
> > "derekul" wrote:
> >
> > > i need a formula for to calculate price and parts so the total price is at
> > > the botom of it
> > >
> > > i have the xls file if anyone needs it

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Structured references don't work in conditional format formulas. Kim Anderson Microsoft Excel Crashes 1 11th Mar 2010 10:53 PM
Conditional Formulas MHSGal Microsoft Excel Worksheet Functions 5 25th Jan 2010 11:27 PM
Conditional Formulas MHSGal Microsoft Excel Worksheet Functions 1 25th Jan 2010 05:54 PM
Conditional use of formulas =?Utf-8?B?TmF0ZSBNTUk=?= Microsoft Excel Worksheet Functions 2 27th Sep 2006 11:00 PM
Conditional formulas =?Utf-8?B?YmlsbHNlcnZpdA==?= Microsoft Excel Misc 4 7th May 2005 12:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:56 PM.