| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If Statements
I'm trying to do an If statement when there's a value in the cell have it
pull another value from a different cell. If no value in the cell have it come back blank. How would I do that? Would I have to have Is Not Null somewhere in the If statement? |
|
#2
|
|||
|
|||
|
Hi
something like =IF(A1="","",A1) -- Regards Frank Kabel Frankfurt, Germany "Penny" schrieb im Newsbeitrag ... I'm trying to do an If statement when there's a value in the cell have it pull another value from a different cell. If no value in the cell have it come back blank. How would I do that? Would I have to have Is Not Null somewhere in the If statement? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if then statements | Excel Discussion (Misc queries) | |||
| Problem with data using IF and Nested IF statements possibly??? | Excel Discussion (Misc queries) | |||
| Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
| If statements | Excel Worksheet Functions | |||
Linear Mode
