| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
ISBLANK Formula Help
Sorry! I meant BF4.
"Peo Sjoblom" wrote: BF is not a cell, it's a column header =IF(BF4="","",(BF4-Y4)/Y4) -- Regards, Peo Sjoblom "pt_lily" wrote in message ... I am hung up on a formula. I am not getting the blank cell as a result. Please help! What I am looking for: If cell BF is empty, I need a blank cell returned. If it has a numerical value in it, I need the formula (BF4-Y4)/Y4 returned. This is the formula that I have currently: =IF(ISBLANK(BF),(""),((BF4-Y4)/Y4)) Any help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| isBlank() | Excel Worksheet Functions | |||
| ISBLANK | Excel Worksheet Functions | |||
| If(ISBLANK) | Excel Worksheet Functions | |||
| ISBLANK Formula Help Request | Excel Worksheet Functions | |||
| ISBLANK | Excel Worksheet Functions | |||
Threaded Mode
