Formula

B

Brandon

I am using a formula, =IF(G2=(A),"",(B))

I need to know what can in input into the "A" field to represent "Any Value
Entered". I thought it would be *.* but it doesn't seem to accept it. Also,
IF the formula is False, what can I input into "B" field so it will leave the
value that is already existing in the cell. Any advice? Thanks.

Example: IF(G2=*.*,"",(Leave it alone) Make sense? :)
 
C

Chuck

Formulae are a bit strange in computer land.
The application or language has a great deal to do with how the expressions
are written.
Next, what is the variable? -- an integer, a decimal number, an alphanumeric
string, a Boolean value, etc
Generally, the values of the variables must be established before the
statement containing the formula can be executed.
Usually, values have some sort of logical range that can be tested before
actual use.
Reverse polish notation can be your friend when writing formulas for
computers.
You may be looking for something like an IF--THEN--ELSE statement.
 
M

macropod

Hi Brandon,

To test whether anything is in G2, you'd use something along the lines of:
=IF(G2<>"",G2,"G2 is empty")
 
Top