Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Aug 2004
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help Needed (2000)

    This is probaly one of the most easiest requests that you excel geniuses have ever had!

    Can anyone help with the attached spreadsheet!

    Thanks in advanced for any help

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Help Needed (2000)

    Here is one way to do this.

    =IF(B3 <> "",IF(C3 <> "",IF(D3 ="","Please input a value for P",""),""),"")
    Regards,

    Gary
    (It's been a while!)

  3. #3
    New Lounger
    Join Date
    Aug 2004
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help Needed (2000)

    top man!

    Thanks for your time

  4. #4
    New Lounger
    Join Date
    Aug 2004
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help Needed (2000)

    Gary,

    What I'm trying to do is validate a use form.

    And it has 3 cells like the d c & p on the example on this thread. And I need an error message to appear any time D C are filled in and P isn't. The formula you gave me worked the once, but after I had deleted D C & P out the formula Wont work again unless I "reset" it

    Is there another way of chucking up an error message, such as using VB or Formatting?

    Thanks for your help

  5. #5
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help Needed (2000)

    I think Gary's formula is good based on how you phrased your problem.

    If D and C are filled in, you get an error message if P is blank. If you fill in D and C and P, the error message goes away.

    If you delete P only, the error message comes back.
    If you delete C only, the error message doesn't come back because P is still filled in.

    In other words, the error message only appears when D and C are not blank and P is blank. Any other situation does not produce the error message.

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help Needed (2000)

    It sounds like you are putting that formula into colemn D (the P value column) where it is replaced when the P value is entered into that column. The formula would need to be put into another cell, possibly column E to work like you want.
    Legare Coleman

Posting Permissions

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