equals something

Mike · Aug 25, 2006

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!

Toppers · Aug 25, 2006

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 · Aug 25, 2006

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)

Rob · Aug 25, 2006

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

Toppers · Aug 25, 2006

Try:

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

Mike said:
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)

Mike · Aug 25, 2006

Awesome, that is exactly what I needed, thanks!

Toppers said:
Try:

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