Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help
HI, worksheet formulas are not one of my best, so I need a little help
once again from the forum. Here is a if formula that I started with, but it does not suit my needs, I also looked at or ways beside the If. IF(AH10=1,(BB1=" ")) What I' trying to do is say the if AH10 =1 then I want cell BB1 to be blank. I need the formula to be in cell BB2. Thanks for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help
On Mar 2, 3:29*pm, Charles wrote:
HI, worksheet formulas are not one of my best, so I need a little help once again from the forum. Here is a if formula that I started with, but it does not suit my needs, I also looked at or ways beside the If. IF(AH10=1,(BB1=" * ")) What I' trying to do is say the if AH10 =1 then I want cell BB1 to be blank. I need the formula to be in cell BB2. Thanks for any help. I think you'd have to put the formula in BB1. Also, from your message, it's not clear what should be in BB1 if AH10<1. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help
"Charles" wrote:
What I' trying to do is say the if AH10 =1 then I want cell BB1 to be blank. I need the formula to be in cell BB2 You cannot put a formula into BB2 that will change the content of BB1. Perhaps what you mean is the following: BB2 should be the value in BB1 if AH10<1, otherwise BB2 should appear to be blank. For that, put the following formula into BB2: =IF(AH10=1,"",BB1) Note the use of the null string (""), not some number of blanks. That will facilitate changes that you might need to make in other formulas that reference BB2, if any. For example, the formula =A1*BB2 might need to be changed to =IF(BB2="","",A1*BB2). ----- original message ----- "Charles" wrote in message ... HI, worksheet formulas are not one of my best, so I need a little help once again from the forum. Here is a if formula that I started with, but it does not suit my needs, I also looked at or ways beside the If. IF(AH10=1,(BB1=" ")) What I' trying to do is say the if AH10 =1 then I want cell BB1 to be blank. I need the formula to be in cell BB2. Thanks for any help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help
On Mar 2, 2:51*pm, jayray wrote:
On Mar 2, 3:29*pm, Charles wrote: HI, worksheet formulas are not one of my best, so I need a little help once again from the forum. Here is a if formula that I started with, but it does not suit my needs, I also looked at or ways beside the If. IF(AH10=1,(BB1=" * ")) What I' trying to do is say the if AH10 =1 then I want cell BB1 to be blank. I need the formula to be in cell BB2. Thanks for any help. I think you'd have to put the formula in BB1. Also, from your message, it's not clear what should be in BB1 if AH10<1. jayray, Thanks for the reply. BB1 will be populated via code with text like "TPON" and others Similar text. What I was trying to do is set BB1 to blank if AH10=1. Prior to the code I stared BB1 had a formula which ref. AH10. and this populated BB1 with the desired text. And I thought a formula could be in BE1, not BB2 that would look at AH10 and set BB1 to "" if AH10 was grater than or equal to 1. If this is not possible, then I will look at adding code to validate what is in AH10. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help
On Mar 2, 3:02*pm, Charles wrote:
On Mar 2, 2:51*pm, jayray wrote: On Mar 2, 3:29*pm, Charles wrote: HI, worksheet formulas are not one of my best, so I need a little help once again from the forum. Here is a if formula that I started with, but it does not suit my needs, I also looked at or ways beside the If. IF(AH10=1,(BB1=" * ")) What I' trying to do is say the if AH10 =1 then I want cell BB1 to be blank. I need the formula to be in cell BB2. Thanks for any help. I think you'd have to put the formula in BB1. Also, from your message, it's not clear what should be in BB1 if AH10<1. jayray, Thanks for the reply. BB1 will be populated via code with text like "TPON" and others Similar text. What I was trying to do is set BB1 to blank if AH10=1. Prior to the code I stared BB1 had a formula which ref. AH10. and this populated BB1 with the desired text. And I thought a formula could be in BE1, not BB2 that would look at AH10 and set BB1 to "" if AH10 was grater than or *equal to 1. If this is not possible, then I will look at adding code to validate what is in AH10. Joe User, Thanks for your reply. From what your saying it looks like I will need a validation code to check AH10 and set BB1 to the desired condition. Thanks to all who looked and reply. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Excel Formula Guidance. Formula need to determine if cell is popul | Excel Programming | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |