Thread: IF function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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