If statement help

[Morlin]

I am trying to work something out with an "IF" statement.

=IF(D2<E2,"40","")

What I'm trying to make it do is that if D2 is less than E2 I want it
to put the value already in E2 in the new cell instead of 40.

What do i put in the second "" to make it list the E2 number?

I apologize if this is simple but I am trying to teach myself this
stuff and am having problems.

 

[Patrick Molloy]

=IF ( D2<E2, 40, E2)

 

[JoeU2004]

I am trying to work something out with an "IF" statement.
=IF(D2<E2,"40","")

First, I suspect that should be:

=if(D2<E2, 40, "")

"40" with quotes is text, whereas 40 without quote is a number. Of course,
you might intend the text "40"; but that is unusual.

What I'm trying to make it do is that if D2 is less than E2 I want
it to put the value already in E2 in the new cell instead of 40.
What do i put in the second "" to make it list the E2 number?

If I understand you correctly:

=if(D2<E2, E2, "")

Alternatively, perhaps the formula you are looking for is:

=if(D2<E2, E2, 40)

That returns 40 if D2 is not less than E2. I'm not sure of your intentions.


----- original message ------