Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula question

    I use the formula below to tell me if the value in any my fields is >=0 then flag it as true, otherwise it's false. I was wondering how i can modify it to say if my value in d2 = 0 or null than flag it as false? Any suggestions? Thanks...

    =IF(OR(H2<=0,K2<=0,L2<=0,M2<=0),TRUE,FALSE)

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If I understood correctly:
    =AND(D2<>0,D2<>"",OR(H2<=0,K2<=0,L2<=0,M2<=0))
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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