Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: IF formula

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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??

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Surrey, United Kingdom
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •