equals something
 

Okay, I know how to say "When a cell equals nothing" (="", or =0), but how
would I say "When a cell equals something", whether a letter, symbol,
number... anything?

Please help!

equals something
 

Try:

=IF(A1<"","something", "null(or empty)")

"<" means "not equal to" / "does not equal"

so above test if A1 does not equal NULL (empty) i.e. equals something

HTH

"Mike" wrote:

Okay, I know how to say "When a cell equals nothing" (="", or =0), but how
would I say "When a cell equals something", whether a letter, symbol,
number... anything?

Please help!

equals something
 

Okay, that all makes sense, but for some reason it is not working with my
situation... tell me what you think.

this is my formula: =sumif(G4:74,"=null",F4:F74)
I've also tried: =sumif(G4:74,"<''",F4:F74)



"Toppers" wrote:

Try:

=IF(A1<"","something", "null(or empty)")

"<" means "not equal to" / "does not equal"

so above test if A1 does not equal NULL (empty) i.e. equals something

HTH

"Mike" wrote:

Okay, I know how to say "When a cell equals nothing" (="", or =0), but how
would I say "When a cell equals something", whether a letter, symbol,
number... anything?

Please help!

equals something
 

You could use (<"") ie < and signs
which means not = to blank.

Other forms you can use in formulas....
= (Greater than or = to)
<= (Less than or = to)

Rob

"Mike" wrote in message
...
Okay, I know how to say "When a cell equals nothing" (="", or =0), but how
would I say "When a cell equals something", whether a letter, symbol,
number... anything?

Please help!

equals something
 

Try:

=SUMIF(G4:G74,"<",F4:F74)

"Mike" wrote:

Okay, that all makes sense, but for some reason it is not working with my
situation... tell me what you think.

this is my formula: =sumif(G4:74,"=null",F4:F74)
I've also tried: =sumif(G4:74,"<''",F4:F74)



"Toppers" wrote:

Try:

=IF(A1<"","something", "null(or empty)")

"<" means "not equal to" / "does not equal"

so above test if A1 does not equal NULL (empty) i.e. equals something

HTH

"Mike" wrote:

Okay, I know how to say "When a cell equals nothing" (="", or =0), but how
would I say "When a cell equals something", whether a letter, symbol,
number... anything?

Please help!

equals something
 

Awesome, that is exactly what I needed, thanks!

"Toppers" wrote:

Try:

=SUMIF(G4:G74,"<",F4:F74)

"Mike" wrote:

Okay, that all makes sense, but for some reason it is not working with my
situation... tell me what you think.

this is my formula: =sumif(G4:74,"=null",F4:F74)
I've also tried: =sumif(G4:74,"<''",F4:F74)



"Toppers" wrote:

Try:

=IF(A1<"","something", "null(or empty)")

"<" means "not equal to" / "does not equal"

so above test if A1 does not equal NULL (empty) i.e. equals something

HTH

"Mike" wrote:

Okay, I know how to say "When a cell equals nothing" (="", or =0), but how
would I say "When a cell equals something", whether a letter, symbol,
number... anything?

Please help!