IF function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Back
Top