If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IsBlank
Hi,
I have a colleague who wants to use the IsBlank formula as follows: For example, the cells in column A will have some numbers in, or will have no data in at all. The formulae have been simplified to help: column B will look into column A and ask If(IsBlank(A1),"",A1/10) this works fine. The problem arises in column C which then asks (If(IsBlank(B1),"",B1*2) The formula doesn't see cell B1 as blank. Is there a way to get the formula to see cell B1 as blank? I have suggested If(B1="","",B1*2), but he doesn't want to use this and would prefer Excel to see B1 as a blank cell. Many thanks |
#2
|
|||
|
|||
IsBlank
Hi Mark,
For Column C why don't you refer to Column A, if Column B is blank then Column A will also be blank. -- Regards Warren Excel Novice If this helps please click the Yes button. "Mark Costello" wrote: Hi, I have a colleague who wants to use the IsBlank formula as follows: For example, the cells in column A will have some numbers in, or will have no data in at all. The formulae have been simplified to help: column B will look into column A and ask If(IsBlank(A1),"",A1/10) this works fine. The problem arises in column C which then asks (If(IsBlank(B1),"",B1*2) The formula doesn't see cell B1 as blank. Is there a way to get the formula to see cell B1 as blank? I have suggested If(B1="","",B1*2), but he doesn't want to use this and would prefer Excel to see B1 as a blank cell. Many thanks |
#3
|
|||
|
|||
IsBlank
I would, but the actual formulae is more complicated than that, I just
simplified it to make it easy to understand what the problem is. Thanks anyway "Warren Easton" wrote: Hi Mark, For Column C why don't you refer to Column A, if Column B is blank then Column A will also be blank. -- Regards Warren Excel Novice If this helps please click the Yes button. "Mark Costello" wrote: Hi, I have a colleague who wants to use the IsBlank formula as follows: For example, the cells in column A will have some numbers in, or will have no data in at all. The formulae have been simplified to help: column B will look into column A and ask If(IsBlank(A1),"",A1/10) this works fine. The problem arises in column C which then asks (If(IsBlank(B1),"",B1*2) The formula doesn't see cell B1 as blank. Is there a way to get the formula to see cell B1 as blank? I have suggested If(B1="","",B1*2), but he doesn't want to use this and would prefer Excel to see B1 as a blank cell. Many thanks |
#5
|
|||
|
|||
IsBlank
Hi,
Why bother with these tests at all. In B1 =A1/10 In c1 =B1*2 The apply a conditional format to both to turn the Font while if A1 is blank =$A$1="" Mike "Mark Costello" wrote: Hi, I have a colleague who wants to use the IsBlank formula as follows: For example, the cells in column A will have some numbers in, or will have no data in at all. The formulae have been simplified to help: column B will look into column A and ask If(IsBlank(A1),"",A1/10) this works fine. The problem arises in column C which then asks (If(IsBlank(B1),"",B1*2) The formula doesn't see cell B1 as blank. Is there a way to get the formula to see cell B1 as blank? I have suggested If(B1="","",B1*2), but he doesn't want to use this and would prefer Excel to see B1 as a blank cell. Many thanks |
#6
|
|||
|
|||
IsBlank
Thank you Sandy, I thought that might be the case but didn't know if there
was a way. "Sandy Mann" wrote: I have suggested If(B1="","",B1*2), but he doesn't want to use this and would prefer Excel to see B1 as a blank cell. But B1 isn't blank, it contains an empty string. You could use IF(LEN(B1)=0,"",B1*2) but you can't use ISBLANK() on a cell that is not blank. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Mark Costello" wrote in message ... Hi, I have a colleague who wants to use the IsBlank formula as follows: For example, the cells in column A will have some numbers in, or will have no data in at all. The formulae have been simplified to help: column B will look into column A and ask If(IsBlank(A1),"",A1/10) this works fine. The problem arises in column C which then asks (If(IsBlank(B1),"",B1*2) The formula doesn't see cell B1 as blank. Is there a way to get the formula to see cell B1 as blank? I have suggested If(B1="","",B1*2), but he doesn't want to use this and would prefer Excel to see B1 as a blank cell. Many thanks |
Thread Tools | |
Display Modes | |
|
|