Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |