IF function

[B G]

I know absolutely nothing about IF functions but I know I want to use one in
a spreadsheet.

Basically I want multiply by $10 the amount in column T (a weight) if the
amount in column F equals PB ( a disposal site).

Can someone please give me a little assistance. Thanks
--
Barb

[mrice]

Try

=if(F1 = "PB",10*T1,"")

into a cell on row 1

[Ron Coderre]

Try one of thse:

=(T1*10)*(F1="PB")

or

=IF(F1="PB",T1*10,"")

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP


"B G" wrote:

> I know absolutely nothing about IF functions but I know I want to use one in
> a spreadsheet.
>
> Basically I want multiply by $10 the amount in column T (a weight) if the
> amount in column F equals PB ( a disposal site).
>
> Can someone please give me a little assistance. Thanks
> --
> Barb

[Toppers]

Something like:

=if(F1="PB",T1*10,0)

What if F does not equal PB (amount?) .... what is the required result? In
the above, the answer is 0.

HTH

"B G" wrote:

> I know absolutely nothing about IF functions but I know I want to use one in
> a spreadsheet.
>
> Basically I want multiply by $10 the amount in column T (a weight) if the
> amount in column F equals PB ( a disposal site).
>
> Can someone please give me a little assistance. Thanks
> --
> Barb