| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
FALSE value
Help please,
This formula returns the value I'm looking for =IF(I7="p",G7) in cell J7 only when I7 has a "p" input. When there is not a p in I7, FALSE displays in cell J7. How do I get this to work w/o the "FALSE" showing? I want cell J7 to be blank unless I type p in cell I7. Confused, Keyrookie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 0 instead of false | Excel Discussion (Misc queries) | |||
| Result = to 0 says false | Excel Worksheet Functions | |||
| #REF!, TRUE or FALSE | Excel Worksheet Functions | |||
| $C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give # | Excel Worksheet Functions | |||
| IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
Threaded Mode
