Formula Help

[Charles]

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.

 

[jayray]

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.

 

[Joe User]

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]

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.

 

[Charles]

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.