| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help on an if then statement!
A B C D
E 1 Name Age Country Last Name 2 Sed 22 USA Doe 3 Mike 37 UK Dane My question is this... How can I get cell E1 to turn into a 1 in the case that if and only if there is text in cells a2, b2, c2, d2... if one of them doesnt have text it has to become a 0. Appreciate the help! -- sss |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | 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 | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
Threaded Mode
