Need help with conditional formula (Excel 97)

[Jake D]

Can anyone give me the correct syntax for the following formula:

if A1 is blank, and B1 is more than zero, then display B1, otherwise
display nothing (blank cell)

Thank you

JD

 

[Frederik]

=IF(AND(A1="",B1>0),B1,"")

Success!

 

[Don Guillett]

Look in the help index for
AND
try your separate formulas & then put em together.

 

[Per Jessen]

Hi

The formula for conditional formatting in B1 is:

=OR(A1<>"",B1<=0)

Format text color as white.

Hopes this helps.

 

[Shane Devenshire]

Hi,

If you are really trying to hide the contents of B1 in B1 then you would not
want to set up the formulas in another cell.

If you were using 2007 you could use a different approach but in 97 I
believe the following will work. I don't have 97 on my machines on 2000,
2002, 2003, 2007 (and 2004, 2008 on the mac).

1. Select cell B1 and set the font color to match the background, most
likely white.
2. With B1 selected choose Format, Conditional Formatting and pick Formula
is from the first drop down.
3. In the second box enter the formula
=AND($A1="",$B1>0)
4. Click the Format button and on the Font tab set the Font Color to Black.
5. Click OK twice.