How the conditional formulas work
 

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

How the conditional formulas work
 

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

How the conditional formulas work
 

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

How the conditional formulas work
 

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

How the conditional formulas work
 

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