| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if statements
I need to be able to use the if function based on the cell being empty/blank.
ie if(a1=blank,b1,0) how do i use blank cell in the formula. Thanks |
|
#2
|
|||
|
|||
|
Try in say, C1: =IF(ISBLANK(A1),B1,0)
-- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Tony Houston" <Tony wrote in message ... I need to be able to use the if function based on the cell being empty/blank. ie if(a1=blank,b1,0) how do i use blank cell in the formula. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 If Statements between 2 values Q | Excel Worksheet Functions | |||
| 4 different if statements, not working | Excel Worksheet Functions | |||
| 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
