Need help with IF formula

KLSXRocker · Apr 29th, 2002, 11:40 PM

Hi Listers,

I'm trying to do the following and can't seem to get the correct formula.

If either Cell A1 or Cell A2 equals YES put .25 in Cell A3. If both A1 & A2 equal YES put .50 in A3.

I've tried doing an IF function, as well as trying to do an If-Then-ElseIf function, but I'm not very experienced in Excel and function/formulas. Can anyone help?

Thanx, in advance.

Laura Meeks

Tom Schreiner · Apr 29th, 2002, 11:45 PM

Try this

=IF(AND(A1="YES",A2="YES"),0.5,IF(OR(A1="YES",A2="YES"),0.25,"Neither"))

Tom

Aladin Akyurek · Apr 30th, 2002, 12:11 AM

=COUNTIF(A1:A2,"YES")*0.25

KLSXRocker · Apr 30th, 2002, 12:16 AM

Hi Tom,

Thanx for your suggestion. It didn't work quite right (using the formula you gave me, when both A1 and A2 equaled YES, I came up with the answer Neither, rather than .50), but I'm going to try tweaking it to see if I can get it.

Thanx, again. I really appreciate your assistance.

Laura

KLSXRocker · Apr 30th, 2002, 12:18 AM

Tom,

I apologize...you're formula DID work, it was *me* who blew it! I used the wrong cell references. (No wonder it didn't wanna work!)

Many thanx!!

Laura

Tom Schreiner · Apr 30th, 2002, 12:20 AM

Clever Aladin...

KLSXRocker · Apr 30th, 2002, 12:26 AM

Hi Aladin Akyurek,

I want to thank you for your response. Your formula also worked! You guys are great!!

I'm going to go look closely at each so that I can figure out what I was doing wrong and why your and Tom's formulas work.

Thanx, again, I appreciate your help.

Laura

Albert 1 · Apr 30th, 2002, 12:56 AM

Quote:

On 2002-04-29 23:20, TsTom wrote:
Clever Aladin...

Indeed!

robfritts · Apr 30th, 2002, 01:04 AM

Quote:

On 2002-04-29 23:11, Aladin Akyurek wrote:

=COUNTIF(A1:A2,"YES")*0.25

Nice.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 11:40 PM	#1
KLSXRocker New Member Join Date: Apr 2002 Posts: 4	Hi Listers, I'm trying to do the following and can't seem to get the correct formula. If either Cell A1 or Cell A2 equals YES put .25 in Cell A3. If both A1 & A2 equal YES put .50 in A3. I've tried doing an IF function, as well as trying to do an If-Then-ElseIf function, but I'm not very experienced in Excel and function/formulas. Can anyone help? Thanx, in advance. Laura Meeks

Apr 29th, 2002, 11:45 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Try this =IF(AND(A1="YES",A2="YES"),0.5,IF(OR(A1="YES",A2="YES"),0.25,"Neither")) Tom

Apr 30th, 2002, 12:11 AM	#3
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	=COUNTIF(A1:A2,"YES")*0.25

Apr 30th, 2002, 12:16 AM	#4
KLSXRocker New Member Join Date: Apr 2002 Posts: 4	Hi Tom, Thanx for your suggestion. It didn't work quite right (using the formula you gave me, when both A1 and A2 equaled YES, I came up with the answer Neither, rather than .50), but I'm going to try tweaking it to see if I can get it. Thanx, again. I really appreciate your assistance. Laura

Apr 30th, 2002, 12:18 AM	#5
KLSXRocker New Member Join Date: Apr 2002 Posts: 4	Tom, I apologize...you're formula DID work, it was me who blew it! I used the wrong cell references. (No wonder it didn't wanna work!) Many thanx!! Laura

Apr 30th, 2002, 12:20 AM	#6
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Clever Aladin...

Apr 30th, 2002, 12:26 AM	#7
KLSXRocker New Member Join Date: Apr 2002 Posts: 4	Hi Aladin Akyurek, I want to thank you for your response. Your formula also worked! You guys are great!! I'm going to go look closely at each so that I can figure out what I was doing wrong and why your and Tom's formulas work. Thanx, again, I appreciate your help. Laura