| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help with the "IF" function
Could someone provide me with the syntex for:
IFcell A1 = X and IF cell A2 = Y then cell A3= Yes The values in A1 and A2 are numerical Thanks, Ze'ev |
|
#2
|
|||
|
|||
|
Hi
=IF(AND(A1="X",A2="Y"),"Yes") -- Regards Frank Kabel Frankfurt, Germany "Ze'ev Aviezer" <Ze'ev schrieb im Newsbeitrag ... Could someone provide me with the syntex for: IFcell A1 = X and IF cell A2 = Y then cell A3= Yes The values in A1 and A2 are numerical Thanks, Ze'ev |
|
#3
|
|||
|
|||
|
Thank you (danke) very much!
Ze'ev "Frank Kabel" wrote: Hi =IF(AND(A1="X",A2="Y"),"Yes") -- Regards Frank Kabel Frankfurt, Germany "Ze'ev Aviezer" <Ze'ev schrieb im Newsbeitrag ... Could someone provide me with the syntex for: IFcell A1 = X and IF cell A2 = Y then cell A3= Yes The values in A1 and A2 are numerical Thanks, Ze'ev |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
| how to move user defined function | Excel Worksheet Functions | |||
| change function variable prompts?? | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Linear Mode
