Automaticall display a word

  • Thread starter Thread starter Pheng
  • Start date Start date
P

Pheng

Hi all,

Here is a simple one:

I would like to automatically display a few words under one condition.

When a total amount equals zero, then a word in another cell will
automaticall display a few words. If it is greater than zero, it will
remain clear.

As an example:

If cell A1 = zero, cell B2 will diplay "hello" and if it is greater
than zero it will not display anything.

Cheers,
 
Put this formula in B2:
=if(a1=0,"Hello","")

I'm not sure if it's important, but empty cells look like 0's to formulas in
other cells.

Maybe this is closer to what you want (still in B2):

=IF(AND(A1<>"",A1=0),"Hello","")
 
What if i wanted to test cells A1, A2, A3, A4 and A5 is equal to zero
only then display "hello"
 
One way:

=if(and(a1=0,a2=0,a3=0,a4=0,a5=0),"hello","")

(all 5 cells = 0, then show "hello", right?)
 
Back
Top