IF formula

[duckfoot]

With the formula:

IF(C2=C1,false,C2)

how do i include the condition that: if A2 contains a value (i.e. is not blank) then leave as C2??

 

[Nibbles]

On 2002-04-30 08:29, duckfoot wrote:
With the formula:

IF(C2=C1,false,C2)

how do i include the condition that: if A2 contains a value (i.e. is not blank) then leave as C2??

Duckfoot,

Try:

=IF(C2=C1,false,If(A2<>"",C2,false))

Or if I've understood wrong and you want the value to be C2 only when C2 is not equal to C1 AND A2 is not equal to nothing then:

=If(And(C2=C1,A2<>""),C2,false)

Nibbs
This message was edited by Nibbles on 2002-04-30 08:35