| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add one cell with no equals operator | Excel Discussion (Misc queries) | |||
| if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
| how to run a macro when a calculation equals a certin number | Excel Worksheet Functions | |||
| Apostrophes instead of equals in Excel | Excel Worksheet Functions | |||
| custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
Linear Mode
