Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
is it possaiable to get the if comand to respond with something based on two
cells, if so how is it done Thanks for any help you can give |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
=IF(and(A1="something";B1="whatever"),"OK","bad")
HTH -- AP "Dreamstar_1961" a écrit dans le message de news: ... is it possaiable to get the if comand to respond with something based on two cells, if so how is it done Thanks for any help you can give |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
Yes, first you have to determine the conditions for both cells, the the
logical relation of these conditions, say in this example AND, then this formula =IF(AND(A1="a",B1="b"),"yes","no") returns "yes" if cell A1="a" and cell B1="b". Regards, Stefi €žDreamstar_1961€ť ezt Ă*rta: is it possaiable to get the if comand to respond with something based on two cells, if so how is it done Thanks for any help you can give |
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 |