Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |