Need help with IF formula

KLSXRocker

New Member
Joined
Apr 28, 2002
Messages
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
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Try this

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

Tom
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top