Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula
Hi I would like to ask for assistance setting a formula for a worksheet I am working on. In colum A answers are from 1 tol 7 but colum b only requires answer from people in category 1 and 2 in cat a. How do I automatically fill colum b with the words no response if col a answers 3 to 7. Example below. A B 3 No response 4 No response 1 Yes I have been trying work this out for a while and I am new to using formulas. Any help gratefully received. Thank you. Robert -- bobby30 ------------------------------------------------------------------------ bobby30's Profile: http://www.excelforum.com/member.php...o&userid=35301 View this thread: http://www.excelforum.com/showthread...hreadid=550822 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula
=IF(A1="","",IF(OR(A1=1,A1=2),"Yes","No response"))
Vaya con Dios, Chuck, CABGx3 "bobby30" wrote in message ... Hi I would like to ask for assistance setting a formula for a worksheet I am working on. In colum A answers are from 1 tol 7 but colum b only requires answer from people in category 1 and 2 in cat a. How do I automatically fill colum b with the words no response if col a answers 3 to 7. Example below. A B 3 No response 4 No response 1 Yes I have been trying work this out for a while and I am new to using formulas. Any help gratefully received. Thank you. Robert -- bobby30 ------------------------------------------------------------------------ bobby30's Profile: http://www.excelforum.com/member.php...o&userid=35301 View this thread: http://www.excelforum.com/showthread...hreadid=550822 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |