IF function
 

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

IF function
 

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

IF function
 

Try

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

into a cell on row 1


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=547535

IF function
 

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