Need simple IF formula, please
 

I know this is simple, but I don't know how to write it:

In V1262 I need this formula: If R1262 and Y1262 are the same, then 39 will
appear in V1262. If, however, W1262 and Y1262 are the same, then it will be
38. If again, however, W1262 is less than Y1262, then it will be 37 in V1262.

37, 38 and 39 are simply code numbers.

Thank you.
Connie

Need simple IF formula, please
 

=IF(R1262=Y1262,39,if(W1262=Y1262,38,if(W1262<Y126 2,37)))

Dave
--
Brevity is the soul of wit.


"Connie Martin" wrote:

I know this is simple, but I don't know how to write it:

In V1262 I need this formula: If R1262 and Y1262 are the same, then 39 will
appear in V1262. If, however, W1262 and Y1262 are the same, then it will be
38. If again, however, W1262 is less than Y1262, then it will be 37 in V1262.

37, 38 and 39 are simply code numbers.

Thank you.
Connie

Need simple IF formula, please
 

One way:

V1262: =IF(R1262=Y1262,39,IF(W1262=Y1262,38,IF(W1262<Y126 2,37,"")))

Note that if none of the conditions apply, the null string is returned.




In article ,
Connie Martin wrote:

I know this is simple, but I don't know how to write it:

In V1262 I need this formula: If R1262 and Y1262 are the same, then 39 will
appear in V1262. If, however, W1262 and Y1262 are the same, then it will be
38. If again, however, W1262 is less than Y1262, then it will be 37 in V1262.

37, 38 and 39 are simply code numbers.

Thank you.
Connie

Need simple IF formula, please
 

=IF(Y1262=R1262,39,IF(Y1262=W1262,38,IF(Y1262W126 2,37))) will work.
However, what if R, Yand W are equal to Y?

"Connie Martin" wrote:

I know this is simple, but I don't know how to write it:

In V1262 I need this formula: If R1262 and Y1262 are the same, then 39 will
appear in V1262. If, however, W1262 and Y1262 are the same, then it will be
38. If again, however, W1262 is less than Y1262, then it will be 37 in V1262.

37, 38 and 39 are simply code numbers.

Thank you.
Connie

Need simple IF formula, please
 

Thank you very much to both of you, Dave and Kassie. How simple! Why
couldn't I have figured that out. I think I try to complicate things too
much. Connie

"Connie Martin" wrote:

I know this is simple, but I don't know how to write it:

In V1262 I need this formula: If R1262 and Y1262 are the same, then 39 will
appear in V1262. If, however, W1262 and Y1262 are the same, then it will be
38. If again, however, W1262 is less than Y1262, then it will be 37 in V1262.

37, 38 and 39 are simply code numbers.

Thank you.
Connie

Need simple IF formula, please
 

Thank you very much. So simple. I guess I'm too complex!

"JE McGimpsey" wrote:

One way:

V1262: =IF(R1262=Y1262,39,IF(W1262=Y1262,38,IF(W1262<Y126 2,37,"")))

Note that if none of the conditions apply, the null string is returned.




In article ,
Connie Martin wrote:

I know this is simple, but I don't know how to write it:

In V1262 I need this formula: If R1262 and Y1262 are the same, then 39 will
appear in V1262. If, however, W1262 and Y1262 are the same, then it will be
38. If again, however, W1262 is less than Y1262, then it will be 37 in V1262.

37, 38 and 39 are simply code numbers.

Thank you.
Connie