View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Morlin Morlin is offline
external usenet poster
 
Posts: 8
Default If statement help

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.