| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ISBLANK Formula Help
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISBLANK Formula Help
=IF(ISBLANK(BF4),"",(BF4-Y4)/Y4)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISBLANK Formula Help
BF is a column (which is a collection of many cells).
Do you want to return a blank if ALL the cells in column BF are blank? or Do you want to return a blank if ANY of the cells in column BF are blank? or Do you want to return a blank if a specific cell in column BF is blank? -- Gary''s Student - gsnu200728 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ISBLANK Formula Help
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. |
|
#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. |
| Reply |
| 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 | |||
Linear Mode
