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
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