Nesting Functions
I want to use two criterias for an answer?? If Column A contains a 1 and
Column B says Yes then return a 1 But if column B is blank return 0.. Then at the same time if column A contains anything 1 and Column B says Yes return a 2 but if column B is blank return zero Thanks For any suggestions M |
=IF(AND(A1=1,B1="Yes"),1,IF(AND(A11,B1="Yes"),2,0 ))
"LostNFound" wrote in message ... I want to use two criterias for an answer?? If Column A contains a 1 and Column B says Yes then return a 1 But if column B is blank return 0.. Then at the same time if column A contains anything 1 and Column B says Yes return a 2 but if column B is blank return zero Thanks For any suggestions M |
=IF(B1="",0,IF(AND(A1=1,B1="Yes"),1,IF(AND(A11,B1 ="Yes"),2,"")))
-- HTH RP (remove nothere from the email address if mailing direct) "LostNFound" wrote in message ... I want to use two criterias for an answer?? If Column A contains a 1 and Column B says Yes then return a 1 But if column B is blank return 0.. Then at the same time if column A contains anything 1 and Column B says Yes return a 2 but if column B is blank return zero Thanks For any suggestions M |
ignore this, use bob's. forgot you wanted to only look fro B being BLANK.
"Dave R." wrote in message ... =IF(AND(A1=1,B1="Yes"),1,IF(AND(A11,B1="Yes"),2,0 )) "LostNFound" wrote in message ... I want to use two criterias for an answer?? If Column A contains a 1 and Column B says Yes then return a 1 But if column B is blank return 0.. Then at the same time if column A contains anything 1 and Column B says Yes return a 2 but if column B is blank return zero Thanks For any suggestions M |
On Thu, 3 Mar 2005 12:31:05 -0800, "LostNFound" wrote:
I want to use two criterias for an answer?? If Column A contains a 1 and Column B says Yes then return a 1 But if column B is blank return 0.. Then at the same time if column A contains anything 1 and Column B says Yes return a 2 but if column B is blank return zero Thanks For any suggestions M Using IF statements: =IF(AND(A1=1,B1="Yes"),1,IF(AND(A11,B1="Yes"),2,0 )) Different and perhaps more obscu =(A11)*(B1="Yes")*2+(A1=1)*(B1="Yes") --ron |
All times are GMT +1. The time now is 08:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com