I'm new to functions and formulas in Excel. I need to write a series of
functions:

If cells A3, A8, and A12 are greater 4, then the result is 3.
If cells A2, A7, OR A11 equal 3, then the result is 2
If cell A1 equals 1, then the result is 0
The results for all other cells within the range of 1 through 12 is 1

Work on this logic:
=IF(AND(A34,A84,A124),3,"")

HF
-----Original Message-----
I'm new to functions and formulas in Excel. I need to
write a series of
functions:

If cells A3, A8, and A12 are greater 4, then the result
is 3.
If cells A2, A7, OR A11 equal 3, then the result is 2
If cell A1 equals 1, then the result is 0
The results for all other cells within the range of 1
through 12 is 1


.

Thanks, GerryK. What does "" do?

"GerryK" wrote:

Work on this logic:
=IF(AND(A34,A84,A124),3,"")

HF
-----Original Message-----
I'm new to functions and formulas in Excel. I need to
write a series of
functions:

If cells A3, A8, and A12 are greater 4, then the result
is 3.
If cells A2, A7, OR A11 equal 3, then the result is 2
If cell A1 equals 1, then the result is 0
The results for all other cells within the range of 1
through 12 is 1


.

Returns a blank in your cell if the criteria is not true.
Did the sox win?
-----Original Message-----
Thanks, GerryK. What does "" do?

"GerryK" wrote:

Work on this logic:
=IF(AND(A34,A84,A124),3,"")

HF
-----Original Message-----
I'm new to functions and formulas in Excel. I need to
write a series of
functions:

If cells A3, A8, and A12 are greater 4, then the
result
is 3.
If cells A2, A7, OR A11 equal 3, then the result is 2
If cell A1 equals 1, then the result is 0
The results for all other cells within the range of 1
through 12 is 1


.


.

Thanks, again.

Well, as a matter of fact, the Sox did with the World Series. But I think
that news was pretty well disseminated. For those of us who waited for Sox
to win, it was a surreal experience.

"GerryK" wrote:

Returns a blank in your cell if the criteria is not true.
Did the sox win?
-----Original Message-----
Thanks, GerryK. What does "" do?

"GerryK" wrote:

Work on this logic:
=IF(AND(A34,A84,A124),3,"")

HF
-----Original Message-----
I'm new to functions and formulas in Excel. I need to
write a series of
functions:

If cells A3, A8, and A12 are greater 4, then the
result
is 3.
If cells A2, A7, OR A11 equal 3, then the result is 2
If cell A1 equals 1, then the result is 0
The results for all other cells within the range of 1
through 12 is 1


.


.