Thread: Formula Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
jayray jayray is offline
external usenet poster
 
Posts: 45
Default 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.