Excel Formulas

[*JimmyJ*]

What is the formula in excel which will multiply 2 number in two different cells, into a third cell?

i.e

qty price total
3 £10.00 £30.00



please help

 

[daviebroon]

f3[total column]=(F1 [qty column] x F2 [price column]) for example.

yer shittin me right?

 

[*JimmyJ*]

f3[total column]=(F1 [qty column] x F2 [price column]) for example.

yer s**ttin me right?

Why do you say that?

 

[Griff]

=SUM(B3*C3)

Assuming B column is quantity and C column is price.

(The "3" is just the row I used for the example)

 

[Mells]

^ lol, a school bursar asked me the other day how she could work out 20% of col A. If she worked for me I would have sacked the idiot.

 

[daviebroon]

^ lol, a school bursar asked me the other day how she could work out 20% of col A. If she worked for me I would have sacked the idiot.

lol, my BOSS asked me how to get roman numerals on a word documents.

"i've tried opening the character map, but its not on there"

 

[*JimmyJ*]

=SUM(B3*C3)

Assuming B column is quantity and C column is price.

(The "3" is just the row I used for the example)

Wicked thats the one!

 

[*JimmyJ*]

im not that bad but just hate excel.

 

[*JimmyJ*]

ok heres one for ya if i copy the formula down it will display £0.00 in all cells unless i enter a value in the quantity cell and price cell, How do I get the formual to still apply but not show £0.00 in the other cells?

 

[Mells]

ok heres one for ya if i copy the formula down it will display £0.00 in all cells unless i enter a value in the quantity cell and price cell, How do I get the formual to still apply but not show £0.00 in the other cells?

several ways, but the easy way is:

highlight the cell > right click it > under number tab select custom > copy and past this in:

#,###;[Red]-#,###

It will make all the 0 disappear unless there is a number in the box.

 

[jprlaw]

=if(a1<>"",a1*b1,"")

Translated into english:
If A1 is not blank, calculate A1 times B1
If A1 is blank, return nothing

 

[@Spoonie]

=if(isblank(a2),"",+a2*b2)

 

[*JimmyJ*]

Need to add up vat how do I do it?

 

[Griff]

Need to add up vat how do I do it?

Multiply the amount by 1.175.