Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2009
    Location
    Western Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,
    I am hoping someone out there can assist me with a formula.
    I have attached the spreadshhet that i need help with.
    What i need is the follwing,
    H14 to = F14-G14 IF D14 =1
    I14 to = F14-G14 IF D14 =2
    J14 to = F14-G14 IF D14 =3

    Thanks:Peter
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    H14's formula
    IF(D14=1,F14-G14,0)

    I14's formula
    IF(D14=2,F14-G14,0)

    J14's formula
    IF(D14=3,F14-G14,0)

  3. #3
    New Lounger
    Join Date
    Sep 2009
    Location
    Western Australia
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you for your assistance.
    Peter

Posting Permissions

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